Efficient Tables
Efficient Tables
(OP)
im looking for a more efficient way to specify two variables (row and column heading) and then having excel return a value from an array of numbers. presently i am using H&VLOOKUP functions but they seem to put a limit on the number of rows that are allowed in the array.
cheers
duncs
cheers
duncs





RE: Efficient Tables
GOOD LUCK.
RE: Efficient Tables
Anyhow, could try :
Match function to establish the row - use FALSE setting if exact match required.
Match function to establish the column number
Then use Address function to get cell address based on row plus constant and column plus constant
Then use indirect function to get contents of cell addressed.
Not sure if there is any limit on the match functions.
RE: Efficient Tables
How can I email you a copy through the forum?
RE: Efficient Tables
that would be great if you could do that, here is my email duncanhundley@hotmail.com
cheers
duncan