Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookups
Hi all,
I have an hlookup that works as hlookup is intended however I am trying to return the value of a cell 1 column to the right of the hlookup result. Any one know how to do this? TIA Steve |
#2
|
|||
|
|||
Use the Match and Offset functions instead.
Use Match to find the column number, then use Offset to increment the column with one. "Steve Wright" wrote in message news:1118194454.39438@muldoon... Hi all, I have an hlookup that works as hlookup is intended however I am trying to return the value of a cell 1 column to the right of the hlookup result. Any one know how to do this? TIA Steve |
#3
|
|||
|
|||
Ta
Works fine Steve "Nuraq" wrote in message ... Use the Match and Offset functions instead. Use Match to find the column number, then use Offset to increment the column with one. "Steve Wright" wrote in message news:1118194454.39438@muldoon... Hi all, I have an hlookup that works as hlookup is intended however I am trying to return the value of a cell 1 column to the right of the hlookup result. Any one know how to do this? TIA Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Copying data within worksheets with lookups | Excel Discussion (Misc queries) | |||
Lookups vs Match | Excel Worksheet Functions | |||
2 way lookups | Excel Worksheet Functions | |||
Double Lookups | Excel Worksheet Functions |