Auto-Insert Adjacent Cell Contents to Cell Chosen by LARGE Formula

**Aravisea** · 04-23-2009, 01:20 PM

Hi all -

I have two columns of data. Column A (A1:A10) contains only text. Column B (B1:B10) is entirely numerical. Beneath my 10 rows of numerical data (B1:B10), I have 5 LARGE functions to pick out the five largest values in the second column's range and display them, after a space of a few rows, under the data in that column (in B13:B17).

In the cells next to this, A13:A17, I need whatever text in the A column was next to the 5 numerical values that were pulled by the LARGE functions to appear automatically.

So - if the LARGE formula determined that the largest number in the Column B range was 23, and 23 appeared in B9, then the number 23 will appear in, say, B13. In A13, I need whatever text was in A9 to appear, since that corresponds to B9, which was chosen by the LARGE formula.

I haven't been able to write a formula to do this.

Any help is HUGELY appreciated!

**JBeaucaire** · 04-23-2009, 01:28 PM

This is an INDEX/MATCH function. In A13 try this:

=INDEX($A$1:$A$10,MATCH(B13,$B$1:$B$10,0))

Deeper Explanation:
http://www.excelforum.com/excel-gene...ame-row.html#3

Sample file:
http://www.excelforum.com/attachment...tch-sample.xls