In column C I want to insert a formula that will compare my criterion (a number between 1 and 10) and show me the corresponding letter from that same row.

However, I don't know if a formula exists that can handle repeated numbers (e.g., in the range A1:A10, the number "1" appears three times, but with different letters in the corresponding rows of column B).

In column C, I only want the first reference (from column B) of the "1" to appear, and in Column D the second reference (from column B) to appear, and in column E the third reference from column B to appear.

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Terms of Use
Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of Tickling Keys, Inc.