How to combine IF/AND with INDEX & Match???

mistone ✭✭✭✭
edited 01/19/23 in Formulas and Functions

I'm looking to combine IF AND with index and match. I've gotten this far and I'm stuck. I'm trying to INDEX and MATCH data from 2 reference sheets and combine it with IF AND.

=IF(AND(INDEX({3.0 IRS - Panera Column}, MATCH([23 Itinerary]@row, {3.0 IRS - Itinerary Range}, 0)) = 1, (INDEX({MLRS - Pre-Departure Email Col}, MATCH([23 Meeting Location]@row, {3.0 MLR - Meeting Location Col})) = 0), "ORDER", "NONE"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!