| Home |
| Search |
| Today's Posts |
|
#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,,,)" |
| 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 | |||
Threaded Mode
