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

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

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