cell references / offset

  • Thread starter Thread starter dave
  • Start date Start date
D

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
 
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)
 
my range is wider then one column - I think this only
works if your range is 1 column. Any other thouights?
 
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
 
Back
Top