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


  • Paul NewcomePaul 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.

  • Fred DoddsFred 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 NewcomePaul 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?

  • Fred DoddsFred Dodds ✭✭✭✭

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

  • Fred DoddsFred Dodds ✭✭✭✭
    Accepted Answer

    The solution was =IFERROR(INDEX({ContactEmail}, MATCH([email protected], {ContactName}, 0)), "")

    Thanks for all the help!

Sign In or Register to comment.