|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
something like this?
this may get you started... |
#3
|
|||
|
|||
Thank you ufopilot.....that is a huge help! I have never used the HLOOKUP formula before. The check boxes are also completely new to me but they offer a lot more flexibility to what I want to do. I appreciate you taking the time to respond!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying data related to one item to worksheet with many instances of the same item | nmp13 | Excel | 3 | 02-06-2016 02:13 AM |
VBA Powerpoint slide table data to combobox item | janism22 | PowerPoint | 0 | 03-25-2015 05:05 AM |
Loosing Formatting on Data in dropdown box | arshaw | Word | 5 | 02-26-2013 12:37 PM |
Match two sets of data and display specific data | lolly150 | Excel | 1 | 05-14-2012 10:33 PM |
How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |