Check to See if Contents of a Cell are Found on Two Other Worksheets

[EvolutionJulie]

Tab One is shipping data from my shipping software. Tab Two is UPS regular shipping cost details from a csv version of a bill. Tab Three is UPS duties & taxes details from a csv version of a bill.

I want to see if the tracking number on Tab One is found on either Tab Two or Tab Three.

I used to put all of the UPS data on one tab and used the following formula: =NOT(ISERROR(MATCH([@[Tracking '#]],JunUPS[Tracking '#],0))) This returns a TRUE value if the tracking number was found on Tab Two and a FALSE value if the tracking number isn't on Tab Two.

But now I've broken out the UPS data across two different tabs and I don't know how to change the formula on Tab One to look for the tracking number on either one of those tabs and return TRUE if it finds it on either tab.

Right now my only solution is to add another column to Tab One with this formula: =NOT(ISERROR(MATCH([@[Tracking '#]],JunUPSDAT[Tracking '#],0)))

But I'd love it if I could get one formula to see if it finds a match on two other tabs. Is that possible?

[TMS]

You don't need to use NOT(ISERROR(MATCH which will get complicated over multiple sheets. You could just use COUNTIF for each sheet, add them together, and check for a non-zero value ... that will tell you if it's on one of the sheets. Check the COUNTIFs individually if you need to know which sheet.