Thread: if formula to check text and paste link
View Single Post
  #3   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

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

Reply With QuoteReply With Quote