Value range lookup - M Query

Hi

Im trying to determine a price bracket by using a looku table which has a price from column and a price to e.g.

Price Bracket     Price From   Price To

100K - 125K      100000        125000

I have tried merging the lookup table as a cartesian join to my trans table then creating a flag column to filter by eg "If Price >= [Price From] and Price <= [Price To] then 1 else 0 (Filter = 1). It works but as anticipated runs like a 'dog', taking hours to process. Is there a slicker way please rather than resorting to {if price >= 100,000 and price <= 125000 then "100k-125k" elseif price >= 125001 and .... etc etc

Thank you in anticipation!