Good Morning all!
I am needing help with matching a cell using a wild card and finding match in a column with a wild card in another sheet and return Cell A of same row. This is the formula I began with
INDEX(A:A,MATCH("*"&B3&"*","*"&Sheet2!A:A&"*"),0) Thank you in advance!!
SHEET 1
A B
Name ID
Smith CO21493
SHEET 2
A
ID Name
CR-DO-FO-03-21493.com
I am needing help with matching a cell using a wild card and finding match in a column with a wild card in another sheet and return Cell A of same row. This is the formula I began with
INDEX(A:A,MATCH("*"&B3&"*","*"&Sheet2!A:A&"*"),0) Thank you in advance!!
SHEET 1
A B
Name ID
Smith CO21493
SHEET 2
A
ID Name
CR-DO-FO-03-21493.com