Finding exact matches with VLOOKUP. - 1  If you're trying to use the VLOOKUP or HLOOKUP function for an exact match, that could by the more common use. In this worksheet called ExactMatch, we've got a formula in cell F2. 2  We're about to use VLOOKUP as an exact match.
sensitivity - the ability to respond to physical stimuli or to register small physical amounts or differences; a galvanometer of extreme sensitivity; the sensitiveness of Mimosa leaves does not depend on a change of growth
Specificity is a measure of the ability of a test to correctly classify an individual as healthy or disease-free. Parikh and others reckons that sensitivity and specificity are inversely proportional, which means that as the value of sensitivity increases, the value of specificity decreases and vice versa.