Compare numbers to a tolerance range

Formulas on sheet-1 amended. After further review, it only seems necessary to search in the one column for values related to a specific tolerance input.

=IF(NOT(ISNA(MATCH($B$2,C8:C13,1))),OFFSET($A$7,MATCH($B$2,C8:C13,1),0,1,1),"No Match")

Also amended the CF formulas to work with the tolerance ranges to highlight the entire row if all inputs fall within tolerance.

On Sheet2: revised criteria formula to improve matching tolerances by padding the values. If there are matches, then the AF returns blanks, otherwise all records are returned.