Thread: [Solved] How do I make a checkbox or dropdown item reference data in that specific section of the data array?
View Single Post
 
Old 02-15-2016, 04:55 PM
dhare dhare is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Feb 2016
Location: Harrisburg, PA
Posts: 2
dhare is on a distinguished road
Default How do I make a checkbox or dropdown item reference data in that specific section of the data array?
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!
Reply With Quote