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