Hi All - I am trying to pull in a value (email address) based on first and last names being true/matching.
The first sheet column A has the first name, column B has last name.
The second sheet has column A with the first name, column B with the last name, and C with the email address.
I am trying to get the formula to find the first and last name from the first sheet in the second sheet and return the matching email address. I don't want to use a helper column if possible.
Thanks in advance.
The first sheet column A has the first name, column B has last name.
The second sheet has column A with the first name, column B with the last name, and C with the email address.
I am trying to get the formula to find the first and last name from the first sheet in the second sheet and return the matching email address. I don't want to use a helper column if possible.
Thanks in advance.