A | B | C | D | E | F |
21 | 3 | 6 | 10 | 1 | 3 |
22 | 5 | 10 | 20 | 2 | 4 |
I have a chart that is similar to the above (just many more data pts). I want to be able to query the data to return a result. I will have a data input for A, and a Number that will be between B & C, OR C & D. It needs to return either a result in column E (if the Number is between B&C) OR column F (if the number is between C&D). So if A = 22, and the number is 11, then the answer is 4. Is there a formula I can use for this? An IF statement?