Hi,
I have an 2 columns, One is an array showing the number of defects /
million .
The other shows its corresponding Sigma Rating.
In another worksheet-2 there exists a similar list. (2 columns)
How can i find "the nearest match" to a particular value (no. of
defects) from the first worksheet in the second,then display the
corrresponding Sigma Rating ( in workseet 2) of the matched value in
worksheet (2).

Thanks !