Match ID Numbers Found in Col on 2nd Worksheet to IDs on 1st Wksht and Mark Somehow

Hi, trying to figure out what I believe is a VLOOKUP formula that is just a bit over my head. I've attached a sample file here to use as an example.

I have an email list of about 2,500 rows or so on a worksheet labeled MASTER. One column (B) lists a 6-digit ID number for each user. There are cases where more than 1 user/row may include the same ID number.

Then, in a second worksheet labeled SELECTS I have about 500 or so rows that list the ID Numbers that I need to filter out of the MASTER list somehow. So this worksheet also has a column for ID numbers (D).

- I need to know the formula that would find all of the IDs on Worksheet 2 (SELECTS) that match the IDs on Worksheet 1 (MASTER) and then put a mark of some sort in a column on the MASTER worksheet that I'll call 'MATCH' (E). If the mark in the MATCH column could be the ID number, that might work OK. But even if it's just an 'X' or something, I can make do and sort/find/replace.

- In cases where an ID in the SELECTS worksheet cannot be found in the MASTER, I'll need to put some sort of mark so I know to add those manually later. That could be in a separate column in SELECTS labeled 'UNMATCHED' (H) or something.

- If there are multiple instances of the same ID in the MASTER list, I'll need all that match a value in SELECTS to be marked.

- Super Bonus: There are a few cases in the MASTER list where there are multiple comma-delimited IDs listed (e.g, 12240,12250,12260) instead of just a single value. If the formula could match these if the ID in SELECTS was at least one of those listed numbers, that would be ideal. If too complex, theres few enough that I could do those manually.


THANKS IN ADVANCE FOR ANY DIRECTION HERE!

Wow, fantastic. That does appear to work and is a different approach than I might have looked into. Seems simple enough.

I also found this VLOOKUP formula for if/when I want the actual ID values in the column, instead of just an 'X' or something.

Please Login or Register  to view this content.

UNFORTUNATELY, and probably as expected, neither of these formulas matches the rows that have multiple IDs in the ID number column (e.g, "14207, 14212, 14260").
In a BEST CASE scenario, the formula(s) would match if it any of the IDs in the comma-delimited cell matched an ID from the source. While there are only about a dozen or so of these rows total, it still takes much longer than expected to manually try to see if there are any matches.

- Any ideas how to modify either of these formulas to match if any one or more of the 5-digit IDs listed in a single cell would match the source?

It would still need to be a perfect match of one of the complete 5-digit ID numbers, not a partial match of some of the numbers in an ID.

THANKS AGAIN!