Hello,
I am looking for a formula to search the email addresses in cell A1 in Sheet 1 and return the value of the names from Column A in Sheet 2. I would like for the return value to be in Column B of sheet 1.
I am looking for a formula to search the email addresses in cell A1 in Sheet 1 and return the value of the names from Column A in Sheet 2. I would like for the return value to be in Column B of sheet 1.
Sample.xlsx | |||
---|---|---|---|
A | |||
2 | |||
Sheet1 |
Sample.xlsx | |||
---|---|---|---|
A | |||
5 | |||
Sheet2 |