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.
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!
-
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?
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!
-
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?
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!
-
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!