I am working with a multi page spreadsheet where I would like to lookup data
on another sheet. If I were to develop fixed coding it would look as
follows:
VLOOKUP(A3,Reports!A2:W60000,13,0)
The problem is that this sheet would have hundreds of rows with each having
5-6 cells with various versions of this lookup. This equates to a lot of
lookup time when in 90% of the applications there will be less then 100
records in the source file(Report), but I need to prepare for the biggist
file I could encounter on the Reports sheet.
Todate, I have learned how to use FOR loops and index addressing to
determine the number of records in a file and limit my search to that area,
but I cannot figure out how to use index addressing with the lookup
function.
As always, any help would be appreciated,
Craig