| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Offset help
I want to do a vlookup on from one worksheet to another - When I find
the value I'm looking for I want to return the next column, but one row above. Function? thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup Offset help
Hi,
You would use index match for that =INDEX(Sheet2!B1:B20,MATCH(A1,Sheet2!A1:A20)-1,0) This looks for the value in a1 on the current sheet in column A of sheet 2 and returns column B 1 row up Mike " wrote: I want to do a vlookup on from one worksheet to another - When I find the value I'm looking for I want to return the next column, but one row above. Function? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with offset? | Excel Worksheet Functions | |||
| offset within vlookup | Excel Discussion (Misc queries) | |||
| offset off a vlookup? | Excel Discussion (Misc queries) | |||
| VLOOKUP and OFFSET | Excel Worksheet Functions | |||
| Offset VLookup | Excel Worksheet Functions | |||
Linear Mode
