Hello All,
I want to create a formular to return a value by searching a partial text. For example, in Sheet 2 col B, I want to search Sheet 2 col A (ID001) from the partial text of Sheet 1 Col A (ID001 - Name 1) and return the value of Sheet 1 Col B to Sheet 2 Col B (Yes).
Sheet 1:
Col A Col B
ID001 - Name 1 Yes
ID002 - Name 2 No
ID003 - Name 3 No
Sheet 2:
Col A Col B
ID001 [Return Value]
ID003 [Return Value]
Thanks for your help in advance.
Bookmarks