Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset, VHookup - Confused
Currently, I'm using Hlookup to find an employee's name, then return the
value in the cell directly below. However, I also need to get the value in the cell directly to the right of that value. For instance if I'm looking for John Doe and his name appears in cell b29, I need to return the values in B30 and B31. Here's what currently returns the valuein B30 =HLOOKUP(C5,'Jan 06'!B29:Y30,2,FALSE) I see several references to Index/Match/Indirect... I'm confused. How do I get the value in B31 in a new cell? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset Function | Excel Worksheet Functions | |||
Offset Function | Excel Worksheet Functions | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Question for use of offset and range | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions |