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
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.