Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell value in forumla
Hi, I need to enter the value of another cell, as a cell reference, into 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, Steve -- steev_jd ------------------------------------------------------------------------ steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107 View this thread: http://www.excelforum.com/showthread...hreadid=529154 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell value in forumla
Try match(B7,indirect(J5)) -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=529154 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell value in forumla
Do you mean
=MATCH(B7,"D"&MATCH($B4,$D$1:$D$7985,0)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "steev_jd" wrote in message ... Hi, I need to enter the value of another cell, as a cell reference, into 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, Steve -- steev_jd ------------------------------------------------------------------------ steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107 View this thread: http://www.excelforum.com/showthread...hreadid=529154 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell value in forumla
Hi, The 'Indirect' method works perfectly. Thanks for your help. -- steev_jd ------------------------------------------------------------------------ steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107 View this thread: http://www.excelforum.com/showthread...hreadid=529154 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Excel GURUs help. (How to make program parse more than 1 forumla within a cell) | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) |