Formula to pull highest possible value from a table

[wallstreetwiz]

Hello,

I want to pull a value from one table into another, but it cannot be a value that is listed in a specific list (which continually grows). I have a blank table which I want to automatically populate with a value from a database that is sorted in descending order. The formula needs to pull the highest value, but if the same value is listed in a separate list, it needs to then take the next highest available value. Any guidance on this would be extremely helpful. Thank you in advance.

Thanks

 

[Aladin Akyurek]

What do you mean by "a database"? Is it not a data area in some spreadsheet?

 

[wallstreetwiz]

My apologies, I should have been more specific. The "database" is actually just a thousand+ row column on another sheet.

 

[Aladin Akyurek]

My apologies, I should have been more specific. The "database" is actually just a thousand+ row column on another sheet.

You could perhaps post a 10 row sample from your data along with the result list you want to have?

 

[wallstreetwiz]

On the roster table, I would like cell C3 to populate with the players last name in column C of the database sheet (those cells are sorted based on total points in column BG). When a player name is inputted into the "Drafted Players List", I would like that player to be excluded from the formula in cell C3 of the roster table. It is my goal to have the formula automatically populate with the players name who has the highest value in cell BG of the database sheet. As players are added to the drafted list, it would automatically the next highest ranked player who is available.

I know that my need for help is for recreational purposes, but this will go a long way for my office fantasy football league. I appreciate your help thus far, and any further assistance you can offer.
Thanks!

 

[Aladin Akyurek]

I'm sorry this is not what I asked for. Rather a small sample that can be read directly into Excel's cells.

 

[wallstreetwiz]

I am not sure exactly how to do that

 

[Aladin Akyurek]

I am not sure exactly how to do that

Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste.

 

[wallstreetwiz]

Excel 2012
	B	C	D	E	F	G	H	I	J
1	Roster							Drafted Players
2	Position	Player Name	Player ID Number	Bye Week					(List Drafted Players Below)
3	Quarterback	Manning	3291	4				1	Manning
4	Running Back	#N/A		#N/A				2
5	Running Back	#N/A		#N/A				3
6	Wide Receiver	#N/A		#N/A				4
7	Wide Receiver	#N/A		#N/A				5
8	Tight End	#N/A		#N/A				6
9	Flex (RB/WR/TE)	#N/A		#N/A				7
10	Team Defense/Special Teams	#N/A		#N/A				8
11	Place Kicker	#N/A		#N/A				9
Moch Roster & Draft Inputs

Cell Formulas
Range	Formula
C4	=VLOOKUP(D4,'Running Back'!A$2:C$292,3,FALSE)
C5	=VLOOKUP(D5,'Running Back'!A$2:C$292,3,FALSE)
C6	=VLOOKUP(D6,'Wide Receiver'!A$2:C$292,3,FALSE)
C7	=VLOOKUP(D7,'Wide Receiver'!A$2:C$292,3,FALSE)
C8	=VLOOKUP(D8,'Tight End'!A$2:C$292,3,FALSE)
C9	=VLOOKUP(D9,'Running Back'!A$2:C$292,3,FALSE)
C10	=VLOOKUP(D10,'Defense & ST'!A$2:C$292,3,FALSE)
C11	=VLOOKUP(D11,Kicker!A$2:C$292,3,FALSE)
C3	=VLOOKUP(D3,Quarterback!A2:C92,3,FALSE)
D3	=VLOOKUP((MAX(Quarterback!G2:G92)),Quarterback!G2:H92,2)
E3	=VLOOKUP(D3,Quarterback!A2:F392,6,FALSE)
E4	=VLOOKUP(D4,'Running Back'!A$2:F$364,6,FALSE)
E5	=VLOOKUP(D5,'Running Back'!A$2:F$364,6,FALSE)
E6	=VLOOKUP(D6,'Wide Receiver'!A$2:F$364,6,FALSE)
E7	=VLOOKUP(D7,'Wide Receiver'!A$2:F$364,6,FALSE)
E8	=VLOOKUP(D8,'Tight End'!A$2:F$364,6,FALSE)
E9	=VLOOKUP(D9,'Running Back'!A$2:F$364,6,FALSE)
E10	=VLOOKUP(D10,'Defense & ST'!A$2:F$364,6,FALSE)
E11	=VLOOKUP(D11,Kicker!A$2:F$364,6,FALSE)

 

[Aladin Akyurek]

Thanks for the exhibit. In fact, what wee need are two exhibits: input and output. The former must consist of a small sample and the latter of outcome you want to see (without any formulas).