So trying to build a spreadsheet for my daughter for a game she got for Christmas. Each card has a value 1-3. I can build the data validation and I have the VLOOKUP correct, but I'm trying to figure out how to make it to where she can only select the number of things that the card value is. So for example:
Ron Weasley has a Spellbook Value of 1, Harry Potter has a Spellbook Value of 2, and Snape has a Spellbook Value of 3.
If she selects Ron, I only want 1 of her Validation Lists cells to become useable. Harry, I only want 2 of her Validation Lists cells to become usable. Snape, she should be able to use all 3 Validation Lists.
Hope I laid this out correctly to where someone can help me out. Thanks.
Ron Weasley has a Spellbook Value of 1, Harry Potter has a Spellbook Value of 2, and Snape has a Spellbook Value of 3.
If she selects Ron, I only want 1 of her Validation Lists cells to become useable. Harry, I only want 2 of her Validation Lists cells to become usable. Snape, she should be able to use all 3 Validation Lists.
Hope I laid this out correctly to where someone can help me out. Thanks.