Sql similar to Excel's PROCV

In excel there is the PROCV function, where I can get close values by comparing columns.

Ex:

 A            B
Nome         Dinheiro
Maria        200
João         1000

D                  E          F
Categoria          Min        Max
Médio              0          200
Alto               201        1000

If I use PROCV (B2, E: F, 1.0) call, it would return the closest value between Min, Max in case the result would be "High".

Is there something similar in Sql, other than BETWEEN?