Hi,
I am trying to create a formula where an entered email address automatically populates the person's name associated with that email in an adjacent column (see below). The data is referenced from a master sheet of people's email/name contact information. I have this function in a different sheet and it works perfectly using the formula below.
Sheet 1:
=INDEX({Physician Name}, MATCH([Submitted By Email]@row, {Email from TRA Contact Sheet}, 0))
where "Submitted by email" is matched to the name -- "{Physician Name}" -- of that person's email in the reference sheet "TRA Contact Sheet."
Sheet 2:
If I cut and paste this formula exactly as is into a new sheet I am creating, and adjust the Match Column name for the new sheet, but keep the same references, it is not working and giving the wrong name:
=INDEX({Physician Name}, MATCH([Employee Email]@row, {Email from TRA Physician Contact}, 1))
Of note, if I put a "0" at the end for unsorted like in the original formula, it gives me a "NO MATCH" error. It only works (incorrectly) if I put "1"
One thing to note is that in the Sheet 1, the email is being autopopulated by a form. In Sheet 2, I am manually typing the email address and it is populating from contact list of saved users in SS.
Any ideas??
Thanks in advance.
