Thanks to all who answered! I have my formula thanks to your help!!

Noodlehounds.

"noodlehounds" wrote:

I am looking for the formula to look up values/range in column A and provide
the correlating value in column B

ie

A B
1 8499 0.12
2 8500 - 13499 0.14
3 13500 0.16

Thanks in advance!!!