Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2020, 09:03 AM
jthomas666 jthomas666 is offline How to populate multiple columns with a single dropdown selection Windows 10 How to populate multiple columns with a single dropdown selection Office 2016
Competent Performer
How to populate multiple columns with a single dropdown selection
 
Join Date: Jun 2016
Location: Birmingham & Warner Robins
Posts: 127
jthomas666 will become famous soon enough
Default How to populate multiple columns with a single dropdown selection

Tracking a bunch of different reports on a spreadsheet, blah blah blah.

My boss has asked me to put additional info on the spreadsheet. His suggestion was to use lots and lots of columns, which offends my delicate sensibilities.

The attached sheet will let you see the problem more clearly. on sheet 2, I have a 3 column list.

on sheet two, those three columns are in the middle of the spreadsheet. Right now, I have a drop down that allows me to select an option for the Column A. What I would like is to be able to select an item for Column A, and have the spreadsheet populate columns A, B, and C based on the list on sheet 2.

Can that be done? If so, how?




Thanks
Attached Files
File Type: xlsx blah.xlsx (15.4 KB, 3 views)
Reply With Quote
  #2  
Old 03-26-2020, 10:33 AM
p45cal p45cal is offline How to populate multiple columns with a single dropdown selection Windows 10 How to populate multiple columns with a single dropdown selection Office 2019
Expert
 
Join Date: Apr 2014
Posts: 365
p45cal is a jewel in the roughp45cal is a jewel in the roughp45cal is a jewel in the rough
Default

d4:
=VLOOKUP($C4,Sheet2!$B$4:$D$9,2,0)
e4:
=VLOOKUP($C4,Sheet2!$B$4:$D$9,3,0)
Reply With Quote
  #3  
Old 03-27-2020, 06:30 AM
jthomas666 jthomas666 is offline How to populate multiple columns with a single dropdown selection Windows 10 How to populate multiple columns with a single dropdown selection Office 2016
Competent Performer
How to populate multiple columns with a single dropdown selection
 
Join Date: Jun 2016
Location: Birmingham & Warner Robins
Posts: 127
jthomas666 will become famous soon enough
Default

Thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to populate multiple columns with a single dropdown selection Multiple Selection Dropdown list ajanson Word VBA 36 07-15-2019 08:16 PM
Selection of a dropdown creates another dropdown wih the list krishnamurthy.ka2810 Word VBA 1 04-26-2018 11:44 PM
Link listbox (with multiple columns) to bookmark based on selection dsjk9190 Word VBA 5 01-29-2015 11:28 PM
Macro to populate a text form field based on dropdown selection koloa Word 0 10-20-2011 11:52 AM
How to populate multiple columns with a single dropdown selection moving data from single to multiple columns? mzimmers Excel 3 08-23-2010 08:20 AM


All times are GMT -7. The time now is 01:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft