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

✭✭✭✭
edited 01/19/23

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"))

• ✭✭✭✭✭✭

You have some parenthesis floating around that can be removed.

=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")

• ✭✭✭✭✭✭

You have some parenthesis floating around that can be removed.

=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")

• ✭✭✭✭

Paul - Thanks. I appreciate the help, and that solved the problem!

• ✭✭✭✭✭✭

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!