Use this formula

=INDEX(A$1:A$7,MATCH(LARGE($C$1:$C$7,ROW(A1)),$C$1:$C$7,0))

and copy down and across

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"neurotypical" <neurotypical.289zwz_1148413501.7214@excelforum-nospam.com>
wrote in message
news:neurotypical.289zwz_1148413501.7214@excelforum-nospam.com...
>
> I have a large table that is many columns. I am trying to create a 3
> column "subtable" to condense data that will find the largest values in
> the third column of the main table, then return the corresponding row
> values from the first two columns of the main table. I
>
> I can't do a lookup table because I am dealing with the third column,
> not the first.
>
> I know how to use the LARGE function to return the largest values.
>
> How do return the corresponding values from my first two columns?
>
> I tried using something like this expression I found online, but it
> doesn't seem to be appropriate or I am not making the right tweaks.
>
> =INDEX($A$1:$B$7,LARGE(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)
>
> MANY THANKS FOR YOUR HELP AND THIS FORUM!!!!
>
>
> --
> neurotypical
> ------------------------------------------------------------------------
> neurotypical's Profile:
http://www.excelforum.com/member.php...o&userid=34719
> View this thread: http://www.excelforum.com/showthread...hreadid=544848
>