A B C D E F
1 Month Location Morning Lunch Afternoon Night
2 January WA 2000 100 1000 500
3 January OR 500 300 400 750
4 January CA 750 400 30 550
5 February WA 3 9 100 50
6 February OR 5 200 100 95
7 February CA 8 10 50 85
8 March WA 9 60 200 75
9 March OR 10 75 60 65
10 March CA 5 50 425 55
Value
WA Afternoon March
Can someone please help me with the formula to look for value for "March, WA, Afternoon" using INDEX MATCH?
I can't use index- match when it has 2 columns criteria.
Please help. Thank you
Bookmarks