Howdy Gents:
Have a football pool going and everyone can only pick one team each week, and after they use that team, they can't use them again. I have multiple Sheets, one for each week, and one sheet that is used as a point total. Here's what I can't figure out:
Team1 Team2 Team3Name1
Name2
Name3
Name4
Name5
Basically the page is set up like that. I'm trying to get each person's picks to show up on this sheet while being pulled from a different sheet that is set up like this:
Team PickedName1
Name2
Name3
Name4
Name5
Can't think of the proper way to word it to search in google, and I don't think VLOOKUP works properly with this since the picks are not in alphabetical order.
Have a football pool going and everyone can only pick one team each week, and after they use that team, they can't use them again. I have multiple Sheets, one for each week, and one sheet that is used as a point total. Here's what I can't figure out:
Team1 Team2 Team3Name1
Name2
Name3
Name4
Name5
Basically the page is set up like that. I'm trying to get each person's picks to show up on this sheet while being pulled from a different sheet that is set up like this:
Team PickedName1
Name2
Name3
Name4
Name5
Can't think of the proper way to word it to search in google, and I don't think VLOOKUP works properly with this since the picks are not in alphabetical order.
