Index Match dilemma

Options

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#})), " ")

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!