Lookups

[Steve Wright]

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

 

[Nuraq]

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]

Ta
Works fine

Steve

Use the Match and Offset functions instead.

Use Match to find the column number, then use Offset to increment the column
with one.