Thread: Base the value of one cell on another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
a7n9[_8_] a7n9[_8_] is offline
external usenet poster
  
Posts: 1
Default Base the value of one cell on another

Not very efficient but you can try this formula:


Code
-------------------
=IF(ISNUMBER(MATCH(C2,B5:B237,0)),INDIRECT("A"&MAT CH(C2,B5:B237,0)+4),IF(ISNUMBER(MATCH(C2,C5:C237,0 )),INDIRECT("A"&MATCH(C2,C5:C237,0)+4),IF(ISNUMBER (MATCH(C2,D5:D237,0)),INDIRECT("A"&MATCH(C2,D5:D23 7,0)+4),""))
-------------------

--
a7n

-----------------------------------------------------------------------
a7n9's Profile: http://www.excelforum.com/member.php...fo&userid=3214
View this thread: http://www.excelforum.com/showthread.php?threadid=56293

Reply With QuoteReply With Quote