Get value from another sheet based on value from source sheet

Fred Dodds

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.

Contact issue.PNG

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

Fred Dodds

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

Thanks for all the help!

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.

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

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 Dodds

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

Paul Newcome

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

Fred Dodds

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

Thanks for all the help!