Function for selecting the cell

[Aspharagus]

Hi All,

I am looking for a excel function which can select the cells in which the value I am looking for falls within.
for example, On column A I have values in degrees and column B has values which excel function has to find it for me.
Sometimes the degrees I am looking for falls between the degrees I have in column A, for that I need to do the linear interpolation and to do that, I need the column B value from the previous and after values.
I am looking for function which does that.

 

[hagia_sofia]

Hello, this should return exact match if there is one, if there is not it should return closest from below and above:

=XLOOKUP(K2,A3:A14,B3:B14,XLOOKUP(K2,A3:A14,B3:B14,,{-1,1}))

 

[Aspharagus]

Thanks Mate, this works!. Also please could you provide any way to find the value if the degree lies between 330 to 0 since it is forming the circle.

 

[hagia_sofia]

Hello, I was wondering... my bad of course... Something like this then:

=IF(AND(K2>330,K2<=360),CHOOSEROWS(B3:B14,1,-1),XLOOKUP(K2,A3:A14,B3:B14,XLOOKUP(K2,A3:A14,B3:B14,,{-1,1})))