Vlookup formula needed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup error 1
Help needed 0
Vlookup and return sheet name also 2
Need VLOOKUP to Work Two Ways 0
VLOOKUP with a blank cell 5
VLOOKUP return cell location and hyperlink 0
Use Vlookup to store formulas? 6
Use & with two formulas 2

Back
Top