Thread: [Solved] Using the LOOKUP Command
View Single Post
 
Old 09-05-2008, 03:31 PM
Grapejuice Grapejuice is offline
Novice
 
Join Date: Jun 2006
Location: Toronto Ontario Canada
Posts: 5
Grapejuice
Default Using the LOOKUP Command

I'm using =LOOKUP(999999,A13:A84) for finding the most recent entered Date in a list of dates. Is there a way to modify the line so that it will select the cell prior to the one the current code finds.

Eg: Curently the code spits out the contents of cell A72. I'd lile it to spit out the contents of cell A71.

Thanks in advance.
Reply With Quote