Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and retrieve values 1 row below the normally retrieved val
I'm trying to figure out how to retrieve a value 1 row below the value that
would normally be retrieved with a regular vlookup. As an example below, using 1234 as my lookup value, column A-B as the table array, column index =2, and range lookup ="false" I'd like to return the value "5" instead of "2". Can this be done somehow through an formula? COL A COL B Item # Sales 1234 2 5 3 4 2345 6 7 9 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve data with MAX and VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup to retrieve a hyperlink | Excel Discussion (Misc queries) | |||
Retrieve values from 2 worksheets. | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions |