# Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

```FYI:

```
I have updated my Drop Box BVL Summary Trial.ods sheet.  Here is the link to it (I hope that it works this time):

```
https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0

.

On 3/10/2018 10:57 AM, WA.TWORSX via AOL wrote:
```
```
Hi Again:

```
Well, my previous posting failed, due to the formatting not being carried over in the post. Copy and Paste works okay with a YahooGroup Mailing List, but not here. So, I am making another attempt to present my question/problem, and ask for advice and assistance.
```
```
(I imagine that this problem is not unlike a sales manager ranking the performance of 13 salesmen during a specific period, nor is it unlike determining which of 13 factories produced the highest product output over a specific time period. I have read through Chapter 7 of the Calc vers 3 user's guide, but did not find a solution. Perhaps this problem could more easier be solved using AOO- Base, with which I am not experienced in using.)
```
_____________________________________

AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25  on WIN10-64 Desktop

_____________________________________

```
I am working with a data set that, ultimately, at the end of a bowling tournament will show a collection of bowling scores. At present, there are 13 bowlers participating in the tournament, and that number might increase.
```
See this drop box link, which shows my work thus far:

```
https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0 .
```

```
Cells E25:T25 contain the names of the 13 bowlers.  Cells E33:T44 contain the numerical data of interest (i.e., scores gathered during the tournament's competition phase).
```
```
I used the =LARGE(\$E\$33:\$T\$44;1) thru =LARGE(\$E\$33:\$T\$44;9) to calculate the nine highest scores within the score data of interest; the results are shown in cells E9:E17. This will ultimately be expanded to include the 45 highest bowling scores with the identifying bowler's name for each (qualifying) score. (I have begun doing that in cells G9:I19.)
```
```
I need to correlate the BOWLER'S NAME with each of the HIGHEST SCORES, and fill in the BOWLER's NAME column (cells D9:D17;H9:H19, etc.).  E.g., POSITION 1 shows a score of 233 (in cell F35) and that was by bowler Bob M. (in cell F25).
```
```
Is there a Calc function that will "look up" the appropriate name in Row 25 for each of the remaining HIGHEST SCORES and display the result within the BOWLER's NAME columns?
```
Any suggestions shall be appreciated.

Regards,

VinceB.

```
```

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org