Forum Discussion
Combining IF and INDEX functions
1. I have two sets up numbers
2. As one goes up, the other comes down, and vice versa
3. If they are all pickups, I need to "mark red" if they go over the max amount (68,000)
4. If they are all deliveries, I need to "mark red" if they go over the max amount (102,000)
.....So far, so good - here is the mystery to me.....
How do I combine the two so that it "marks red" if for example...
a. Pickups = 44,000 and deliveries = 36,000 OR
b. Pickups = 16,000 and deliveries = 78,000
1 Reply
Hi Anthony
You could try something like the attached (which does a match on the 2 columns and then compares the matches to see if they have the same row number).
