How to populate multiple columns with a single dropdown selection

		Microsoft Office Forums > Microsoft Excel > Excel
How to populate multiple columns with a single dropdown selection

03-26-2020, 10:33 AM

p45cal

Windows 10 How to populate multiple columns with a single dropdown selection

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

d4:
=VLOOKUP($C4,Sheet2!$B$4:$D$9,2,0)
e4:
=VLOOKUP($C4,Sheet2!$B$4:$D$9,3,0)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
moving data from single to multiple columns?	mzimmers	Excel	3	08-23-2010 08:20 AM

Other Forums: Access Forums

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