VLOOKUP over multiple sheet
I have a new sheet that has Full name and I want to do a VLOOKUP to determine their email address w/o asking them for it.
I need to look across 4 massive sheets (almost 20k rows in each) and when the Full Name is X it returns their email address.
I know how to do this if in 1 sheet but not across 4 sheets.
Sheet names are:
- Employee list 1
- Employee list 2
- Employee list 3
- Employee list 4
Columns on each of those sheets are the same:
- Full name
Any best practices for getting at this?
Help Article Resources
Check out the Formula Handbook template!