software

Hi,

I need to enter the value of another cell, as a cell reference, into
another formula.

I have got the current formula
=CONCATENATE(quot;Dquot;,(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,
Steve--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: www.excelforum.com/member.php...oamp;userid=33107
View this thread: www.excelforum.com/showthread...hreadid=529154
Try match(B7,indirect(J5))--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=529154Do you mean

=MATCH(B7,quot;Dquot;amp;MATCH($B4,$D$1:$D$7985,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;steev_jdquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I need to enter the value of another cell, as a cell reference, into
gt; another formula.
gt;
gt; I have got the current formula
gt; =CONCATENATE(quot;Dquot;,(MATCH($B4,$D$1:$D$7985,0)))
gt;
gt; Which outputs a cell reference in column j, i.e. 'D10' in cell J5
gt;
gt; I then need another forumla which compares two cells, i.e.
gt; =MATCH(B7,D10)
gt; (The D10 value coming from the result of the formula above),
gt;
gt; however I dont know how to do this, I can only get the formula to say
gt; =MATCH(B7,J5)
gt;
gt; Anybody know how to do this?
gt;
gt; Cheers,
gt; Steve
gt;
gt;
gt; --
gt; steev_jd
gt; ------------------------------------------------------------------------
gt; steev_jd's Profile:
www.excelforum.com/member.php...oamp;userid=33107
gt; View this thread: www.excelforum.com/showthread...hreadid=529154
gt;

Hi,

The 'Indirect' method works perfectly.

Thanks for your help.--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: www.excelforum.com/member.php...oamp;userid=33107
View this thread: www.excelforum.com/showthread...hreadid=529154