Using a drop-down list to conditionally choose column data

[dwking1989]

Hi,

I have a large set of data for a group of countries. I was hoping to use a drop-down menu so that a user could select an indicator and that data would then appear for that country in a smaller table. For instance in the screenshot below, selecting the GDP indicator would automatically return GDP values for the country from another sheet in column D, but if you change cell B1 it changes both the indicator and values in column D.

Thanks,

Dave

 

[awoohaw]

IS THIS SOMETHING YOU WANT?

WorkBook1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Indicator	BEAR
2
3							INDICATORS
4	Country	Classification	Region	BEAR			SQUIRREL
5	Ethiopia	LDC	SSA	339			GDP
6	DRC	LDC	SSA	120			LION
7	Nigeria	LMIC	SSA	167			BEAR
8	Afghanistan	LDC	MENA	137
9	Pakistan	LMIC	INDO PAC	257			Country	SQUIRREL	GDP	LION	BEAR
10	Mozambique	LDC	SSA	432			Ethiopia	282	387	276	339
11	Yemen	LDC	MENA	326			DRC	206	418	231	120
12	Kenya	LMIC	SSA	201			Nigeria	243	396	125	167
13	Somalia	LDC	SSA	313			Afghanistan	245	167	152	137
14	Uganda	LDC	SSA	180			Pakistan	227	290	490	257
15	Tanzania	LDC	SSA	294			Mozambique	122	348	460	432
16	Syria	LMIC	MENA	486			Yemen	256	408	474	326
17							Kenya	118	332	251	201
18							Somalia	351	284	254	313
19							Uganda	240	318	478	180
20							Tanzania	294	476	291	294
21							Syria	159	347	197	486
22
Sheet6

Cell Formulas
Range	Formula
D4	D4	=B1
D5:D16	D5	=INDEX($G$9:$K$21,MATCH($A5,$G$9:$G$21,0),MATCH($D$4,$G$9:$K$9,0))

Cells with Data Validation
Cell	Allow	Criteria
B1	List	=INDICATORS

 

[dwking1989]

That worked perfectly. Thanks very much, really appreciate it. Had spent a lot of failed time googling.

 

[awoohaw]

That worked perfectly. Thanks very much, really appreciate it. Had spent a lot of failed time googling.

You're welcome. Please mark the post solved, if that is something you can do.