Joined: 22 Jul 2002
Location: Matthew Parry
| What Function Do I Use?
I am looking for a formula (and, eventually, formulae) that will compare the contents of a cell against a range and produce an answer in a corresponding cell.
For example, Column A contains 10 rows where A1 = 1, A2 = 2 and sop on. Column B contains 10 rows where B1 = A, B2 = B, and so on.
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.
So, if in the range A1:A10, cells A2, A4 and A6 contain "1", and cell B2 = A, B4 = K and B6 = N, then C2 = A, C4 = K and C6 = K.
This may not be possible, but I figured if anyone knows the answer I'll find them here.