Hello,

I am wondering if there is anyway to find a matching of a single value from another cell that may have multiple values that are separated by commas.

For example, can some tool like VLookup find a match for '3' (Sheet 1/Column B/Row 1) from Sheet 2?

Sheet 1
Column A Column B
1 Name A 3
2 Name B 5
3 Name C 6
4 Name D 7


Sheet 2
Column A Column B
1 Name A 1, 2, 3
2 Name B 4, 5
3 Name C 006
4 Name D 7, 8

If I need to provide more explanation, please let me know.