dropdown selection to check various rows withing a range

hello,

this is very complicated, i have a dropdown which is working fine now thank you , the next item i need is to select from the dropdown and compare values within a range of 4 different rows then compare this to a chart to give me a product code to use

could you please suggest a method, i uploaded the test sheet

many thanks

when i select I3 from 0.350 to 0.500 this would refer to all the codes with 0.7 in the D15:D19

from 0.550 to 1.000 would refer to all the codes with 1.0 in D23:D26

then 1.100 to 1.500 would refer to all the codes with 1.5 in D29:D38

then 1.200 to 0.500 would refer to all the codes with 2.0 in D39:D52

hope I've explained ok, the next think would be to arrive at a crease height, per code but with think about this after

This is fantastic thank you.

Another question I want to work out the crease height per board calliper per product code

This is worked out with a start height at 23.80 - the board from the drop down - the value in column D

Thanks again for your help