cell references / offset

[dave]

I have a formula that produces a numerical result by using
hlookup on a given table. I'd like to use the offset
function in order to attain the value one cell to the left
of the value I get from the lokoup. But the offset
function requires a reference and not the numerical result.

Is there a formula that converts the lookup from the value
to the cell reference which contains the value?

tia,
Dave

 

[Frank Kabel]

Hi Dave
if you're currently using HLOOKUP on the range A1:X2 like
=HLOOKUP(value,A1:X2,2,0)

you may use
=OFFSET(A2:X2,0,MATCH(value,A1:X1,0)-2)

 

[Guest]

my range is wider then one column - I think this only
works if your range is 1 column. Any other thouights?

 

[Frank Kabel]

Hi
no this kind of formula would also work for more columns/rows (I used
A-X columns and two rows).
You may post your existing HLOOKUP formula to make it easier to adapt
this