Automate switch to contact email

Katherine Camacho

Hi Community! I have a sheet that has a column of usernames (random letters ex OPKAP) that associate with an email address in the column next to it. I am hoping to possibly manage references or vlookup or something so in a different sheet if i input the username it automatically fills in the users email address. is that possible? Or something i can imbed into the main sheet that makes it recognize the username and input the email?

Paul Newcome

Make sure this column name matches exactly what you have in your sheet:

Username

Paul Newcome

Try a formula along these lines:

=INDEX({Reference Sheet Email Address Column}, MATCH(Username@row, {Reference Sheet Username Column}, 0))

Katherine Camacho

@Paul Newcome that looks like i tshould work but its coming back as #unparseable so im closer but not there.

Katherine Camacho

=INDEX({BOS Jag Usernames Range 1}, MATCH(Username@row,{BOS Jag Usernames Range 2}, 0))

Paul Newcome

Make sure this column name matches exactly what you have in your sheet:

Username

Katherine Camacho

@Paul Newcome I was missing a column in the sheet to match the column in the source sheet. once they got me that put in it all started working! thanks for the great info.

Paul Newcome

Happy to help. 👍️