mjelec
asked on
Populate Multiple Fields with Excel Drop Down
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.
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.
ASKER
Here is a test version.
Equipment-Copy.xlsx
Equipment-Copy.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yup! thanks!
ASKER
NM
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,LOOKUPLIS T,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
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,LOOKUPLIS
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
Dave