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!
Help Article Resources
Categories
Check out the Formula Handbook template!