Comparing competitor products using Drop Down List

[Dorothyhanlon]

Selecting item(product) from Drop Down List auto fills 4 cells below it with items ( competitor products) that are similar(generic) to product selected in the drop down.

 

[L. Howard]

Hi and welcome to the board,

What you want is doable, but where is all the data? Are there always just four compare items to be listed, or perhaps more?

I have a pretty common drop down example, using two sheets. Drop down is on sheet 3 and the data is on sheet 2.
Select a drop down item in cell B2 (sheet 3) and a list of data is posted below the drop down. Some lists are 3 items long some are 23 items long. The number of items listed below the drop down is however many I include on the data sheet (sheet 2) for that particular selected item.

Here is a segment of sheet 2 data with some dummy data. Where My Product 1, My Product 2 My Product 3 wouldbe seen in the drop down and the associated list would be posted below it.

The code to make it work is a change event code in the sheet module.

Does this seem to be what you are looking for?

Howard

Excel 2012
	E	F	G
1	My Product 1	My Product 2	My Product 3
2	Product e	Product p	Product g
3	Product t	Product x	Product r
4	Product x	Product l	Product z
5		Product u	Product zzw
6		Product a	Product awxz
7			Product ttvz
Sheet2

Cell Formulas
Range	Formula
E1	My Product 1
E2	Product e
E3	Product t
E4	Product x
F1	My Product 2
F2	Product p
F3	Product x
F4	Product l
F5	Product u
F6	Product a
G1	My Product 3
G2	Product g
G3	Product r
G4	Product z
G5	Product zzw
G6	Product awxz
G7	Product ttvz

 

[L. Howard]

Just to add, disregard the lower illustration Worksheet Formula, it has no bearing to this solution, was inadvertently included by me.

Howard