Struggling with Formula. Not sure if using correct one.
I have 2 sheets.
We'll call Sheet A "Roster" and Sheet B "Grading Sheet"
Sheet A has columns for "Employee Number" and "Email Address"
What I am trying to do is on Sheet B, have a column in which you can enter the employee number, it reference Sheet A and then it will automatically enter the email address associated with that row on Sheet B in the adjacent column.
I have the sheets referencing, but not sure if I did that right either, along with a "VLOOKUP", but I think I have it all wrong.
Can someone help?
Help Article Resources
Check out the Formula Handbook template!