Thread: Need a Quick answer on this one.........
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Marcotte A[_2_] Marcotte A[_2_] is offline
external usenet poster
  
Posts: 15
Default Need a Quick answer on this one.........
Try,

=IF(A1=B1,C1,IF(A1=C1,B1,IF(B1=C1,A1,"No Match")))

Untested, but should work.
Reply With QuoteReply With Quote