If a cell reads certain text, enter this text here.

[leaper1981]

Hi,

Just wondering if someone can help.............again.

I have a drop down list and would like to have text explaining more about each drop down that is selected, think I've attached the mini-sheet below. any help would be great.

Thanks.

PCI Sample request v2.xlsm
	N
47
SAMPLE REQUEST

 

[dreid1011]

Hi,

Just wondering if someone can help.............again.

I have a drop down list and would like to have text explaining more about each drop down that is selected, think I've attached the mini-sheet below. any help would be great.

Thanks.

PCI Sample request v2.xlsm
	N
47
SAMPLE REQUEST

You have to select the entire range you want to copy with the mini sheet. You only have a single cell there.

 

[leaper1981]

Ah, I guess that would help! Hopefully this shows it, basically under the (carton style required) there is a drop down list and I'd like that when each one is selected that the box below it give further information that I have maybe got saved on another sheet. if that makes sense.

PCI Sample request v2.2.xlsm
	B	C	D	E
42
43		Carton style required
44		CLB
45
46		BOX FOR ADDITIONAL INFO RELATED TO EACH SELECTED OPTION IN C44 DROP DOWN
47
48
49
50
51		Preferred fitment style
52		N/A
53
54
55
56
57
SAMPLE REQUEST

Cells with Data Validation
Cell	Allow	Criteria
E45	List	=DATA!$A$2:$A$17
E49	List	=DATA!$A$20:$A$41
C52:D52	List	=DATA!$A$45:$A$49
C44:D44	List	=DATA!$A$33:$A$43

 

[dreid1011]

Something like this perhaps:

Book1
	C
43	Carton Style Required
44	Style A
45
46	This is style A, size small, color red.
47
48
49
50
51	Preferred Fitment Style
52	N/A
Sheet1

Cell Formulas
Range	Formula
C46	C46	=VLOOKUP(C44,'Another Sheet'!A2:B5,2)&""

Cells with Data Validation
Cell	Allow	Criteria
C44	List	='Another Sheet'!$A$2:$A$5

Book1
	A	B
1	Carton Style	More Info
2	Style A	This is style A, size small, color red.
3	Style B	This is style B, size medium, color orange.
4	Style C	This is style C, size large, color yellow.
5	Style D	This is style D, size x-large, color green.
Another Sheet

You should also update your profile to show what version of Excel you are using, as the solutions will vary.