Lookups-how to do this?

[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" <[email protected]> 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
>
>

[Steve Wright]

Ta
Works fine

Steve

"Nuraq" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> 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
> >
> >
>
>