Excel Compare numbers on 1 tab to other tabs in workbook.
- Thread starter MELISSA68
- Start date
Becky
Webmistress
- Joined
- Mar 25, 2003
- Messages
- 7,424
- Reaction score
- 1,511
Welcome to the forum 
The COUNTIF formula could be used to do this - it looks for specific criteria within a range:
=COUNTIF(range,criteria)
Because your range is split over two sheets, I would also use the OR function, and use the IF function to give your Yes/No result. It could look something like this:
=IF(OR(COUNTIF(Sheet2!A1:C5,B1)>0,COUNTIF(Sheet3!A1:C5,B1)>0),"Yes","No")
Where the green text is the cell on sheet 1 (ie the number you want to find), the red text is the range on sheet 2, and the blue text is the range on sheet 3.
Hope this helps!
The COUNTIF formula could be used to do this - it looks for specific criteria within a range:
=COUNTIF(range,criteria)
Because your range is split over two sheets, I would also use the OR function, and use the IF function to give your Yes/No result. It could look something like this:
=IF(OR(COUNTIF(Sheet2!A1:C5,B1)>0,COUNTIF(Sheet3!A1:C5,B1)>0),"Yes","No")
Where the green text is the cell on sheet 1 (ie the number you want to find), the red text is the range on sheet 2, and the blue text is the range on sheet 3.
Hope this helps!