VLOOKUP Search String Against List of Numbers

I am a little stumped by this. I have a column with application names and unique IDs, comma separated. APPNAME - (APPID), APPNAME - (APPID), etc., variable number of records per row. I have a list of appid numbers as well, and I'd like to mark every row that contains an appid from my list.

So, I have

A | B | C
RowID | Apps | Match?
Row1 | APPNAME - (APPID), APPNAME - (APPID), APPNAME - (APPID), APPNAME - (APPID), APPNAME - (APPID) | X
Row2 | APPNAME - (APPID), APPNAME - (APPID), APPNAME - (APPID) |
Row3 | APPNAME - (APPID) | X

And
A | B
AppID | X

Is there an easy way to do this?

No dice, but maybe I didn't put it in right (or maybe I didn't describe my issue enough). I have a list of APPID numbers that I need to find in bigger strings of varying sizes.

The formula resolves, but it's not returning positive results.

=IF(ISERROR(SEARCH(Sheet1!$A$1:$A$123,BF2)),"","X")

The range specified contains the list of numbers I'm trying to match against, and the cell BF2 contains one of the strings.

Originally Posted by mahju

How your list of App. Id is organized
see attached for an example
Thanks

It is a column of numbers:

APPID
12345
12346
12347
12349
etc.

Originally Posted by newdoverman

If you are trying to determine if APID is in any cell in a row, you can use a formula with this syntax that counts the number of times that APPID is found in the cells A1 to D1. (short example).

Formula:

Please Login or Register  to view this content.

You can then surround this with an IF to give a message instead of a number if you want

Formula:

Please Login or Register  to view this content.

If APPID is an array, will this still work?

I appreciate your guys' help on this.

"APPID," that I'm trying to find in various strings, is a list of several possible values, though. There is not just one APPID to match. Sorry if I was not clear on that.

One hacky solution that I'm playing around with right now is to make an column for each of the 123 possible APPIDs, search the string for each one individually, and then add up the results, anything > 0 being a match.