formula to take text relating to cell and carry into another cell

**tswift01** · 10-16-2012, 02:16 PM

I am a new user and trying to create a formula that will do the following
1- take the top 5 #'s from a column and put into a seperate row
I think I have this one using the =LARGE(D2:D13,1) formula but am open for other suggestions

2- Based on the above results I need to take the text from a cooresponding column to fill into a seperate cell. In this case H2 =D9 and would say dave.

I would like to have G2 thru G6 fill in based on the above values in column H with the text from column C

I have attached my example which I am sure is very basic but greatly appreciate any help.

**Pete_UK** · 10-16-2012, 02:26 PM

Put this in G2:

=INDEX(C:C,MATCH(H2,D:D,0))

then copy down to G6.

Hope this helps.

Pete

**oeldere** · 10-16-2012, 02:27 PM

Maybe like this?

**Haseeb Avarakkan** · 10-16-2012, 02:28 PM

Use INDEX with MATCH,

In G2

=INDEX(C:C,MATCH(H2,D:D,0))

then copy G2 & paste down.

**tswift01** · 10-16-2012, 03:01 PM

Thanks so much for the quick response. That lead me to another question. What if 2 values are teh same? Looks like it takes the 1st name with that value. Any ideas? My main sheet actuall has 2 values for each name, one is a standard # and the other is a % of that number.