S
steev_jd
Hi,
I need to enter the value of another cell, as a cell reference, int
another formula.
I have got the current formula
=CONCATENATE("D",(MATCH($B4,$D$1:$D$7985,0)))
Which outputs a cell reference in column j, i.e. 'D10' in cell J5
I then need another forumla which compares two cells, i.e.
=MATCH(B7,D10)
(The D10 value coming from the result of the formula above),
however I dont know how to do this, I can only get the formula to say
=MATCH(B7,J5)
Anybody know how to do this?
Cheers,
Stev
I need to enter the value of another cell, as a cell reference, int
another formula.
I have got the current formula
=CONCATENATE("D",(MATCH($B4,$D$1:$D$7985,0)))
Which outputs a cell reference in column j, i.e. 'D10' in cell J5
I then need another forumla which compares two cells, i.e.
=MATCH(B7,D10)
(The D10 value coming from the result of the formula above),
however I dont know how to do this, I can only get the formula to say
=MATCH(B7,J5)
Anybody know how to do this?
Cheers,
Stev