Vlookup or Hlookup Offset Vary

[Stringt]

Is there a way within a Vlookup or Hlookup to reference the offset column/row to another cell. Therfore when the cell changes the lookup values change?

Thanks

 

[Aladin Akyurek]

On 2002-02-19 02:01, Stringt wrote:
Is there a way within a Vlookup or Hlookup to reference the offset column/row to another cell. Therfore when the cell changes the lookup values change?

Thanks

Do you mean that you have a name or range in some cell that specifies e.g., a lookup table that you want to use in a VLOOKUP formula?

 

[Stringt]

No. I have a Hlookup like this:
=HLOOKUP($a$1,MyDataRange,2,FALSE)

Which looks up for value in A1, in the range "MyDataRange" and returns the value from offset row 2.

I want the formula to look at some other cell to determine which offset row to look at. e.g. if in cell a30 i have the 2 changes to 4, the Hlookup would now look up offset row 4.

 

[Aladin Akyurek]

Stringt: Your latest post is empty. Please try again.

 

[Aladin Akyurek]

On 2002-02-19 05:02, Stringt wrote:
No. I have a Hlookup like this:
=HLOOKUP($a$1,MyDataRange,2,FALSE)

Which looks up for value in A1, in the range "MyDataRange" and returns the value from offset row 2.

I want the formula to look at some other cell to determine which offset row to look at. e.g. if in cell a30 i have the 2 changes to 4, the Hlookup would now look up offset row 4.

=HLOOKUP($A$1,MyDataRange,A30,FALSE)

where A30 houses a row number.

Aladin