Hi

Something like
=CHOOSE(MATCH($A2,Sheet2!$A$2,$A$10;1),Sheet2!$B$2 :$B$10)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Arjun Chowdhry" wrote in message
oups.com...
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 !