Look a value from the table

[ajmal pottekattil yoousuf]

From the above excel  table we are facing to issue  to find the class of the instrument of comparing the different criteria.

Colud you please guide us to solve this issue.

[#2]

row 6:

50 75 - - 2 2 3 2 5 3


why ans is Class 2?
Class 2
"VMPE (µm)"
2
instead of input 1

[#3]

The Table is Maximum Permissible error of the Instrument
our requirement is checking the instrument is find the VMPE, and EMPE ,
if the user ender the value is less than or equal .
Based on the User Input we want to find the Class of the instrument.

[#4]

@peiyezhu 

For Another Example

Range : 100 - 125 mm

Empe : 1 µm

Vmpe : 1 µm

Comparing the values in the Table the instrument lies in the Class 1.

[#5]

@peiyezhu 

Another Example:

Range : 300 - 325 mm

Empe : 1 µm

Vmpe : 4 µm

Comparing the values in the Table the instrument lies in the Class 2.

Note:  range is greater than 300 instrument class should be either class 2 or class 3,

No need to compare the Class 1 and class 0 Value.

[#6]

I get the Solution. Thanks for the support.