| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup to find cell reference | Excel Discussion (Misc queries) | |||
| Can you lookup a value & get the cell reference? | Excel Worksheet Functions | |||
| two way lookup and cell reference | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
| Search/lookup/cell reference | Excel Worksheet Functions | |||
Threaded Mode
