Thread: IF statement between two worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TrevorC TrevorC is offline
external usenet poster
  
Posts: 7
Default IF statement between two worksheets
I need to see if a value in column A matches a value in column E of Sheet2. I
have tried the following:

=IF($A1='Sheet2'!$E$1:$E$100,"match","false")

Any help is appreciated.
Reply With QuoteReply With Quote