Using VLOOKUP across multiple pages

[gmcfad]

I need to look and see if a name that is on my main page is on one of several other pages. So like:

John Smith

Where I can look for "Smith" and see if it's there across multiple pages - and simply return "yes or no"

I have it working for one page using:

=IF(ISNA(VLOOKUP(B2,'Thursday 730 PM'!B1:B5,1,FALSE)), "No", "Yes")

Where B2 is the data I'm searching for and 'Thursday 730 PM' is one on my page names and B1:B5 is my search column.

Thanks much for any assistance.

[Pete_UK]

You could string a few COUNTIFs together, like this:

=IF(COUNTIF(Sheet1!B:B,B2)+COUNTIF(Sheet2!B:B,B2)+COUNTIF(Sheet3!B:B,B2),"Yes","No")

Change the sheet names, as appropriate.

Hope this helps.

Pete

[gmcfad]

Thanks much!!!

[Pete_UK]

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete