Thread: if formula to check text and paste link
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
qook qook is offline
external usenet poster
  
Posts: 3
Default if formula to check text and paste link
I figured it out on my own:

=IF(C2='[FileB.xls]Sheet1'!$C$2,IF(D2='[FileB.xls]Sheet1'!$D$2,'[FileB.xls]Sheet1'!$N$2))

Reply With QuoteReply With Quote