| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with If-Then Statements/Populating Data based upon selection
I would like to include a drop down in my excel spreadsheet that would
consist of 4 choices. Based upon which choice is selected, I would then like specific data to populate elsewhere in the worksheet. So, for instance, if my 4 choices are Julie, Tom, Rick, and Debbie, if someone selects Julie, information about Julie will populate in all of my other fields. The data about Julie is already in another worksheet. Is there a way that I can use an if-then statement to pull this information over? Or, is there another way to do this? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with If-Then Statements/Populating Data based upon selection
Check out Vlookup() in help
"SK" wrote: I would like to include a drop down in my excel spreadsheet that would consist of 4 choices. Based upon which choice is selected, I would then like specific data to populate elsewhere in the worksheet. So, for instance, if my 4 choices are Julie, Tom, Rick, and Debbie, if someone selects Julie, information about Julie will populate in all of my other fields. The data about Julie is already in another worksheet. Is there a way that I can use an if-then statement to pull this information over? Or, is there another way to do this? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter data in an adjacent cell based on a list selection? | Excel Worksheet Functions | |||
| Populating a field based on lookup values | Excel Worksheet Functions | |||
| Moved data to new sheet based on list selection | Excel Worksheet Functions | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
| Populating cells based on calculation | Excel Worksheet Functions | |||
Linear Mode
