spattedkow
New Member
Hello! I am looking for some help on a formula to help complete a task.
Column A and B are a series for me, so 25-28, 32-37, etc. I'm checking if Column C is between any of the series listed and outputting to Column D. I'm currently using nested if statements, but I could have 150 rows of series to check, so that is becoming inefficient. Is there an easier way to do this?
Column A and B are a series for me, so 25-28, 32-37, etc. I'm checking if Column C is between any of the series listed and outputting to Column D. I'm currently using nested if statements, but I could have 150 rows of series to check, so that is becoming inefficient. Is there an easier way to do this?
25 | 28 | 24 | No |
32 | 37 | 35 | Yes |
48 | 52 | ||
67 | 88 |