Thread: Excel Forumla Help Please! What am I doing wrong?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan C.[_2_] Dan C.[_2_] is offline
external usenet poster
  
Posts: 4
Default Excel Forumla Help Please! What am I doing wrong?
=IF(ISNA(MATCH(B1,Sheet1:Sheet2!B:B)),"No Match","Match")

This formula searches to see if (X) is on sheet 1 or sheet 2. I need it too
search sheet1 and sheet2 too see if it is on both. Anyone help?
Reply With QuoteReply With Quote