hi guys I have two ranges of number in column D and column E, I want to get the fruit in column F if the given number on A2 is between the range of the numbers on column D and column E. I have a sample below. thank you
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Number | Fruit | Start | End | Fruits | |||
2 | 8 | grapes | 1 | 5 | apple | |||
3 | 6 | 10 | grapes | |||||
4 | 11 | 15 | avocado | |||||
5 | 16 | 20 | orange | |||||
6 | ||||||||
7 | ||||||||
Sheet1 |