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