Populate Multiple Fields with Excel Drop Down

mjelec
mjelec used Ask the Experts™
on
I want to create a drop down using data validation and then populate columns based on the data next to the list.

For example, I have a list of equipment on a sheet called equipment and my drop down is a list of all of the equipment codes.  I would like on the first sheet next to the drop downs, the associated data to fill into the next columns.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2012

Commented:
Can you provide a sanitized version of your workbook to work from?

Dave

Author

Commented:
Here is a test version.
Equipment-Copy.xlsx
Most Valuable Expert 2012
Top Expert 2012
Commented:
You mean like this?

Dave
Equipment-Copy.xlsx
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Author

Commented:
Yup!  thanks!

Author

Commented:
NM
Most Valuable Expert 2012
Top Expert 2012

Commented:
First, I inserted a row in the Sheet1 tab, so I could put headers in.

Then, I added a data validation dropdown for the Name list, based on the range of data in Equipment associated with Name.

Finally, I used this formula for the Vlookup:

[B2]=VLOOKUP($A2,LOOKUPLIST,COLUMN(),FALSE)

Note the third parameter (column) is 2 for Prof, 3 for AP, 4 for Price, etc.  If you're putting this VLOOKUP in a different column besides starting in column B, then you'll need to modify to ensure that 2 is for Prof, 3 for AP, etc.

Did that help?

Dave

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial