# Using the LARGE Function and the INDEX function

1. ## Using the LARGE Function and the INDEX function

Aloha,

The focus of this document is to rank order Column C based on the result from Column Q. Column R should identify the largest value of Column Q to the smallest value of Column Q hence the LARGE function which should return the nth largest value from a given set of values (Column Q) in the spreadsheet. I am unable to determine why I am not getting a value in Column R from the values in Column Q.

Column S are the results (Highest value to the lowest value) that should appear in Column T, hence, the INDEX function which should return a value or the reference to a value from within (Column C). I am unable to determine why I am not getting a value in Column T from the values in Column C.

r/
Reggie

2. ## Re: Help with LARGE and INDEX Functions Not Returning Expected Results

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here I have done it for you this time.)

3. ## Re: Help with LARGE and INDEX Functions Not Returning Expected Results

Maybe:

=LARGE(\$Q\$3:\$Q\$9,ROW(A1))

Explain (in words) what you are expecting the INDEX MATCH to do.

In a sample workbook you should mock up the rsults you want, not give us non-working formulae!!!

4. ## Re: Help with LARGE and INDEX Functions Not Returning Expected Results

In T (based on Ali's reply for column R)

=INDEX(\$C\$3:\$C\$9,MATCH(\$R3,\$Q\$3:\$Q\$9,0))

or

=INDEX(\$C\$3:\$C\$9,\$S3)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1