Get value from another sheet based on value from source sheet

I am trying to get the proper or most efficient syntax to take a Contact Name from a source sheet and match the value in a second sheet to then bring back a value from the matching row.

I am attaching a screenshot. Looking for accurate syntax of current function or better function.

Function being used =IFERROR(INDEX({​​​​​​​​LO_Email Contact Name}​​​​​​​​, MATCH([Assigned To]@row, {LO_Email ​​​​​​​​Contact email}​​​​​​​​, 0)), "")

Best Answer

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    So you are wanting to pull the email based on the name? If so, you are going to want to switch your ranges so that you are indexing the email and matching on the name.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Fred Dodds
    Fred Dodds ✭✭✭

    I tried what you said and it didn't work. At least my syntax didn't work. I got the #UNPARSEABLE error.

    Here is what I tried. Both with the same error

    Switching to indexing the email and matching on the name

    =IFERROR(INDEX({LO_Email ​​​​​​​​Contact email}​​​​​​​​, MATCH([Assigned To]@row, {LO_Email Contact Name}​​​​​​​​, 0)), "")

    And tried again if I got your directions confused

    =IFERROR(INDEX({LO_Email ​​​​​​​​Contact email}​​​​​​​​, MATCH(LO_Email Contact Name, {[Assigned To]@row}​​​​​​​​, 0)), "")

    Can you send example of the correct syntax? Thanks!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    The first one should work. And that is giving the #UNPARSEABLE error?


    Can you provide a screenshot of the first one actually in the sheet similar to the below screenshot?


    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Fred Dodds
    Fred Dodds ✭✭✭

    Thanks for the answers. I was able to get it figured out.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to post your solution so that others experiencing similar challenges may be able to find some help here?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Fred Dodds
    Fred Dodds ✭✭✭
    Answer ✓

    The solution was =IFERROR(INDEX({ContactEmail}, MATCH(AssignedTo@row, {ContactName}, 0)), "")

    Thanks for all the help!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!