|Item 1||10215 1601 4510 4542 6546 7271|
|Item 2||10215 10556 1601 4510 4542 6546 7271|
in the cells with multiple numbers I need to know based on the item I need to know if the item has a number that matches a criteria list. I would be fine with changing the font of those numbers that match the criteria or extracting them to another cell. Currently I extract text to columns and then vlookup each column. (for some items there are 10 or 20 numbers.) Followed by a textjoin over the range of lookups It works but is a bit clunky and removing the #N/A's I only succeeded by putting a space so the result from text join has to be edited so that all the multiple spaces are removed. I tried find and replace which really was not ideal either but found an item but would change the criteria of the whole cell so bolding just the matching criteria didn't work either. I am looking for a method of pulling every number that matches the list of criteria and putting them into another cell. without having to extract and vlookup and textjoin. Thanks.