Index Formula Using Multiple Criteria


I'm trying to create an index formula that matches two different columns in a separate sheet but I keep getting #INVALIDVALUE. What am I doing wrong?

=INDEX({02 - Pre-Con Tracker PRECON DATES}, MATCH(Comm@row, {02 - Pre-Con Tracker COMM}), MATCH(Lot@row, {02 - Pre-Con Tracker LOT NUMBER}))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!