View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
parrot parrot is offline
external usenet poster
 
Posts: 8
Default Lookup on the last reference cell

Hello, I am trying to use vlookup on a column containing identcal cells. EX:

Col1 Col2
Sales 150
Costs 75
Sales 80
Costs 40
Sales 120
Costs 60

(Column 1 is not sorted an contains empty records)

The formula should retrieve the first occurance on "Sales" going from down
to the top: 120.
With the usual formula: =VLOOKUP("Sales",A1:B6,2,FALSE), I get 150. Thanks!