Hey fellow excel forumers!
I'm new here but need help with a workbook that I'm trying to do. It centers around a fantasy basketball game that I play for fun and I know I need to use the solver tool to help optimize my lineup as much as possible because doing so manually would be way too much work!

Here are the basic rules:
Every player is assigned a position and I need to construct a roster consisting of 8 players that fall within the following categories:
pg
sg-
sf-
pf-
c-
g-
f-
u-

also, every player has their own price tag and so the salary cap of my lineup is $50,000

i need to also find a way to show that some players have multiple position eligibility. also every player falls within the u(utility) category. for instance, if player x is eligible as a pg/sg(you'll see what i mean in the file) then that person could be slotted in at the pg, sg, g, or u spot. if a player is a sg/sf, then they could be in the sg,sf,g,f, or u spot.
^this is really important

i have the workbook csv ready to work on and I would like help with it. it's attached.

DKSalaries (10).csv