Solved: obtain data from 3 input with conditions

[mtsf26]

i make this table and is it possible to obtain the data from other sheet with 3 input based on length, diameter and quality.please kindly help me to solve it to get the exact data.
how to get the price from HJD-sono tab? If :
1. class = a, price + 10% of price
2. class = b, price + 7.5% of price
3. class = c, price + 5 % of price
4. class = d, price + 2.5% of price
5. class = e, price
i have attached the file too.hope you guys able to help me

[mdmackillop]

Welcome to VBAX
I've taken some liberties with your headers. These could be fixed with hidden rows or custom formatting. The yellow block shows original workings and can be deleted.

[mtsf26]

hey thanks for the reply it really work for row in F2 in xxx but when i randomly choose other like in F7 it not working. it should give the result 2102.1 (from 1911+191.1)

[mdmackillop]

You should be able to see how this works. Have you identified the cause of the error?

[mtsf26]

it work for a few data but it didnt work for other data.here i show u the right answer too,so you can see d different.i also confused.hehe

[mdmackillop]

Add 0.1 to each value in HJD-Sono Column B

[mtsf26]

thanks a bunch for helping me.it work

[bebe0]

hey thanks, that was just what i needed.. ;)