Is there a way to join an input based on a range of values from another input?

I have an input "A" and an input "B" I would like to join. I want to join them based on two columns from input "A" and three columns from input "B". Column Aa matches up to column Ba while column Ab will fall between Bb and Bc. So, say Aa=6.5. I need to find the correct match Ba based on the the value in Ab that falls between Bb and Bc.