Index Match dilemma
I am attempting to access info from another sheet. I have a list and need to attach the correct person to the item. I've tried 2 different formulas, but it's only bringing back the 1st person that it found, not a different person for each item.
Here are the 2 formulas that I've tried. What am I missing?
=INDEX({TO CHECKOUT Puller}, MATCH([CHARAC FABRIC TO#]@row, {TO CHECKOUT TO#}))
=IFERROR(INDEX({TO CHECKOUT Range 2}, MATCH([CHARAC NOTIONS TO#]@row, {TO CHECKOUT TO#})), " ")
Best Answer
-
VLOOKUP stops on the first match the same as INDEX/MATCH.
Try specifying an exact match in your INDEX/MATCH by placing a zero in the third portion of the MATCH function.
Answers
-
INDEX/MATCH will only pull the first row where a match is found. Are you able to provide screenshots for reference?
-
Well that won't work for me then. Bleh! Do I need to stick with VLookUp? I can't provide a screenshot because of security concerns.
-
VLOOKUP works the same way. Are you able to provide a mockup with dummy data?
-
No. With vlookup it matched it correctly.
-
VLOOKUP stops on the first match the same as INDEX/MATCH.
Try specifying an exact match in your INDEX/MATCH by placing a zero in the third portion of the MATCH function.
-
Adding the zero in the 3rd portion of the MATCH function worked. Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 60 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!