How do I make a checkbox or dropdown item reference data in that specific section of the data array?

[dhare]

I want to make an Excel spreadsheet with check boxes for a few different items (ie. RED, BLUE, YELLOW). So when a user "checks' the appropriate box the VLOOKUP function will only look at the data array for that specific item? Maybe the VLOOKUP function is not the correct way to go about this operation. Any help is appreciated!