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