Creating dependent list

[bondie18]

Hello all,

I have a spreadsheet with a number of companies, each one with 3 specific values that I would like to be able to put in and out of spreadsheets.

When I select one of my companies using data validation list I would then like the 3 corresponding values to automatically fill in the next 3 columns however I am currently struggling to achieve this.

Any help would be much appreciated

 

[Peter_SSs]

Welcome to the MrExcel board!

Here is one way. The formula in B1 is copied across to D1.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Company 2	Co2Val 1	Co2Val 2	Co2Val 3				Company 1	Co1Val 1	Co1Val 2	Co1Val 3
2								Company 2	Co2Val 1	Co2Val 2	Co2Val 3
3								Company 3	Co3Val 1	Co3Val 2	Co3Val 3
Company