Hi all,

I posted this the other day but I didn't provide enough information.
I currently have a workbook with approximately 30 worksheets. I have a master worksheet that contains a list of contract numbers (ex. 23985734) about 100 or so.
I want to check and see if all of the contract numbers reside in at least one of the 30 worksheets.

So I would like something like this:

Contract No. Exists/Missing
23985734 Exists (based on formula)
25847156 Missing (based on formula)

Etc....
I would prefer not using VBA. So once my lookup sees a matching contract number the search will stop. I don't care if I have duplicate contract numbers in the various worksheet. It would be nice if my formula would provide the worksheet name it resides in but its not necessary at this time. Also the data in each worksheet is not in the same layout.

I am not able to upload any sample data.
Any help would be greatly appreciated.

Mark R