Excel formula to get certain cell if the value is between 2 numbers

Question

On the left, there is the table I have, on the right the desired output

Table

I tried the following function but only works if the values in D and E are in the same column (E) one under the other

=IF(AND(G1>=$E$3:$E$10;G1<=$E$3:$E$10);"No match!";INDEX($D$3:$D$10;IF.ERROR(MATCH(G1;$E$3:$E$10);1)))

Answer 1

So, first with vlookup():

A formula so you can copy & paste:

VLOOKUP(D2,$A$1:$B$5,2,1)

For those who think vlookup() is a poor choice, here is the use of index() with match(), which needs more typing and no benefit in this situation:

INDEX($B$1:$B$5,MATCH(D2,$A$1:$A$5,1))