Lookup value based on IF

Good morning.. here is my delema...

cat ---- dog ---- apple ---- orange
1 ------ 4 ------ 7 ------- 10
3 ------ 6 ------ 9 ------- 12

The above is a simplified example of waht i'm trying to do...

basically i have a value say (5) I want to check if its in the range of the numbers and return the value in a certain row...

So basically If the value is bigger than whats in the second row and smaller than whats in the third row return the corrosponding value in the first row

in this case for (5) it would be dog... i tried doing this with multiple if statements but i have about 15 columns of info and it tells me that the formula is too big...

Thanks in advance!