Please help me create drop down box using 3 columns

[benjamin Rolliston]

I've created a drop down menu in E1, what i am try to do is link F1 & G1 to the selection i make from the drop down in E1. The example i've given is from A6, B6 & C6. So if i selected Ub-150-14 (A1) from the drop down list (E1) i want 0.58 to appear in F1 and 14.00 in G1. Can some one please show me the steps required to do this. It's driving me mad!

Ultimate Quota.xls
	A	B	C	D	E	F	G
1	UB-150-14	0.58	14.00		UB-180-18	0.69	18.10
2	UB-150-18	0.58	18.00
3	UB-180-16	0.68	16.10
4	UB-180-18	0.69	18.10
5	UB-180-22	0.69	22.20
6	UB-200-18	0.76	18.20
7	UB-200-22	0.91	22.30
8	UB-200-25	0.91	25.40
Data

 

[BigJ]

Use Vlookup using the value in E1 as the reference and looking up on the table in A1:C8.

e.g. F1 would be =vlookup(e1,A1:C8,2,false) - should return the appropriate value from the second column of the table, then for G1, use =vlookup(e1,A1:C8,3,false).

This assumes your dropdown list is created via data validation. If not, make sure your listbox or combobox or whatever is linked to cell E1.