Vlookup formula needed?

K

Kent

Hello,

I have a large spreadsheet that uses vlookup in most of the cells.
What I am wondering is if there is a way to change my vlookup statement so
that the lookup always pulls data from the last cell in a column? I would
like to do this so that as new cells are populated in a column you do not
have to manually update the lookup each time.

Thank you,

Kent
 
M

Mike

Assuming column A for the range and that your lookup criteria are numbers then

=VLOOKUP(INDEX(A:A,MATCH(9.99999999999999E+307,A:A)),A1:B26,2,FALSE)

will take the bottom used cell with a value in column A and use it as the
criteria in the lookup

Mike
 
Top