Excel function to choose a value greater than or less that a particular value in cell -

i have data set this

units   price    1    15  100    10  150    9  200    8 50000   7

i need output price respect quantity.

example- if input value 90 should give price 15 if input 210 should give value 8.

however,sadly cannot use if statement. in advance.

you can use combination of index , match

=index(b1:b5,match(lookup_value,a1:a5,1))

this assumes units in column a , price in column b

make sure understand both functions:

CSS