Thread: can i use a cell value as another sheet's cell reference
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Krishnakumar
 
Posts: n/a
Default can i use a cell value as another sheet's cell reference

Hi,

Try something like..

IF(E5=INDIRECT("'boy-pres'!C"&INDIRECT("'Sheet2'!C5")),...


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=496106

Reply With QuoteReply With Quote