Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset VLookup
I have an excel spread shee with tables and I need to find a value.
1 A B C D E 2 a 3 4 0 0 0 12 I need to Lookup up "a" and return "12" is this possible? I was thinking a Vlookup with Offset but cannot get it to work. Any help is greatly appreiciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset VLookup
I think I figured it out.
"=OFFSET(INDEX(A:E,MATCH(H1,A:A,0),5),3,,,)" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset VLookup
Or simply...
=INDEX(A:E,MATCH(H1,A:A,0)+3,5) Hope this helps! In article .com, wrote: I think I figured it out. "=OFFSET(INDEX(A:E,MATCH(H1,A:A,0),5),3,,,)" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and offset | Excel Worksheet Functions | |||
Offset And Vlookup Combo Help!! | Excel Worksheet Functions | |||
Vlookup then OFFSET over and down | Excel Worksheet Functions | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
offset and vlookup | Excel Worksheet Functions |