Having Trouble Coming up with Combination Lookup value based on Rank Result

[tvieson]

I have the main function of the workbook doing exactly what I need, but I am struggling to get the proper formula to achieve the look I need for Tourney sheets and fish off sheet. We only care about the first 3 finishers. What I would like to accomplish is to show 1st, 2nd, and 3rd. The rest would just show as blank. Now I have the RANK values for the workbook on the worksheet sheet. I'm struggling to create a vlookup formula that when the RANK=1, it will display 1st, 2= 2nd, and 3 = 3rd. I'm sure once I have that figured out. I can adjust/modify the formula for Rank=1 for the Big Bass Field and display BIG BASS for the result.

[AliGW]

Administrative Note:

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. By way of example, I have done it for you this time.)

[tvieson]

I hope that title makes better since. Not sure what I was thinking when I typed that. Think I've been looking at the screen to long.

[AliGW]

Really NOT sure what you want, but in N2 copied down:

=RANK(L2,$L$2:$L$21,0)

and in O2 copied down:

=N2&IF(COUNTIF($N$2:$N$21,N2)>1,"=","")

[AliGW]

And who is BIG BASS???

AliGW on MS365 Insider (Windows) 64 bit

	A
1	ANGLER
2	ANDY TOBE
3	BILL SCHNEIDER
4	BOB FARMER
5	DANNY SCHMITZ
6	DARRELL PENNY
7	ERNIE SHULER
8	HERB JONES
9	JAKE DONAHOE
10	JOSH ZEHLER
11	JUSTIN HEINBOKEL
12	RICK HENSLER
13	STEVE TRAVIS
14	TOM AYNES
15	TONY VIESON

Sheet: WORKSHEET

[AliGW]

And then based on the ranking column, to bring back the name:

=INDEX($A$2:$A$21,MATCH(ROW()-1,$N$2:$N$21,0))

But still really not sure if this is it ...

[tvieson]

It may help if you look at the rest of the workbook. Start with the TOURNEY1 sheet. Look under column E aka PLACE. Using a RANK Formula. It shows who had the largest weight from scanning column C aka WGTS. LBs.
What I would like to do, is instead of display 1 through 20. I would just like to display 1st, 2nd, and 3rd. If your not in the top 3, it will just display a blank field. To accomplishing this, I'm trying to combine, if it can even be done, a vlookup = value with the data im scanning and populating from the worksheet sheet under columns N and O.

Were as you can see that 1 = 1st, 2 = 2nd, 3 = 3rd, and 4 thru 20 = blank. If I can establish that, modifying it for BIG BASS should be easy. There is only 1 BIG BASS per tournament. So a RANK of 1 always Equals Big Bass and anything else would display as blank.

The resulting values will then be exported to using csv and imported to a table I've build through tablepress inside my clubs wordpress site. This allows me to update the workbook book from my phone or tablet and through scripts I've configured. Updates the websites with the latest tournament results instantly.

[AliGW]

OK - I'm sorry, I had the workbook open with the tabs off the bottom of my screen!!!

I think I'll leave this one for someone else - I'm just beginning to wind down for the day (it's early evening here), so son't have time to study this before I close down.

[tvieson]

I appreciate you looking at it.

[JeteMc]

Paste the following into cell E3 and then drag the fill handle down as far as needed:

Please Login or Register  to view this content.

Let us know if you have any questions.

[tvieson]

JeteMc

Thanks for the post. I feel like the answer was starring me in the face. I know I've seen the solution before, but I think I was getting to hung up on the IFERROR statement. I had to slightly modify what you provided, but you found the solution for me and I appreciated it. Thank You again.

Please Login or Register  to view this content.

For 1st through 3rd

Please Login or Register  to view this content.

For BIG BASS

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.