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

mistone

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

Paul Newcome

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 Newcome

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

mistone

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

Paul Newcome

Happy to help. 👍️