How to combine vlookup and search text within cell

[garriebartolome]

Hi All,

I am trying to create a formula for the following scenario but to no avail. Please note that Cell in Col A Sheet1 have multiple values. e.g A1 contains "ID001, ID002, ID003"

Sheet 1:
Col A Col B
ID001, ID002, ID003 Yes
ID004, ID005, ID006 No

Sheet 2:
Col A Col B
ID002 [Return Value = Yes]
ID006 [Return Value = No]