Help!!! Looking to find top 8 values that fall within a constraint.

[PTori82]

Here's the setup. I can send the spread sheet over as well.

Column A: Listed vertically an infinite amount: Harden, Westbrook, Jokic, George, Irving, Mitchell, Gobert, Walker, Gasol, Faried
Column B: Listed vertically an infinite amount: Salary associated with player in column A: 12900, 11000, 10800, 9900, 9600, 8800, 8500, 8100, 7800, 6900
Column K: Listed vertically an infinite amount: 253.85, 236.17, 217.55, 193.28, 186.89, 178.72, 172.06, 165.33, 158.9, 145.33

With this data I am looking to maximize the points in column K of the associated players. But I only have $50,000 to spend. So with the $50,000 (data in column B) I am looking to pick the players that give me the most points under the constraint of only spending 50,000. The results will be shown beginning in column N3.

Thank you!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...all-within-range-post5218678.html#post5218678

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).