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]
Bookmarks