View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kent kent is offline
external usenet poster
 
Posts: 37
Default Vlookup formula needed?

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