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
-
The solution was =IFERROR(INDEX({ContactEmail}, MATCH(AssignedTo@row, {ContactName}, 0)), "")
Thanks for all the help!
Answers
-
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.
-
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!
-
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?
-
Thanks for the answers. I was able to get it figured out.
-
Are you able to post your solution so that others experiencing similar challenges may be able to find some help here?
-
The solution was =IFERROR(INDEX({ContactEmail}, MATCH(AssignedTo@row, {ContactName}, 0)), "")
Thanks for all the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!