compare - Google Sheets - Multipling a cell(weight) by another(rate) based on its value compared to a column of cells -

i want compare value of cell(k5) against column a determine range rate fall under. once proper rate determined, want multiply row values on column b, c, etc , output on cells (l5, m5, etc)

for example if cw(k5) 755.5 range falls under cell a8(500+) can multiply cw(k5) b8 , c8 , output product on l5, m5 respectively.

eventually have many more rows better idea have rates(columns a, b, c) in separate sheet, possible?

the actual sheet

i've made similar data sheet, removed strings actual numbers in column a. , used vlookup sorted range a:c:

the formula f2 is:

=vlookup(e2,$a:$c,2)

the formula g2 is:

=vlookup(e2,$a:$c,3)

this technique may you.