Vlookup email name return name

If I enter email from drop down list in PDCA, match that to column 3 on email worksheet and return the name to the left in PDCA Person Responsible.

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Brandon03

    The values that you're matching across sheets will need to be the same type of value. For example, I can see that in your top screen capture the email is in a Contact Column, but in the bottom screen capture the emails are typed into a Text/Number type of column.

    You will want to standardize these two columns (either both are Text emails, or both are Contact type of values) in order for the VLOOKUP to successfully bring back the name. See: Column Type Reference

    Once you've set up your columns to be matching, I would actually suggest an INDEX(MATCH formula over VLOOKUP.

    An INDEX(MATCH works like this:

    =INDEX({Column with value to return}, MATCH([Value to match]@row, {Column with value to match in the other sheet}, 0))

    Let me know if this makes sense and if it works for you!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!