Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

VLOOKUP over multiple sheet

✭✭✭✭✭✭
edited 05/07/21 in Formulas and Functions

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:

  • EID
  • Full name
  • Email

Any best practices for getting at this?

Thanks.

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions