Simple combo box problem

J

JonathanW

I want to create a combo box that has different present sizes i.e. A4, DL
size etc.
When someone selects say A4 size in the combo box it then puts it data 297
in a cell D1 and 210 in E1
 
T

Toppers

Create a table in columns A to C with:

A: paper size (A4, DL etc)
B: 1st dimension (297, etc))
C: 2nd dimension (210, etc)

Select paper size in D1 using Data Validation...:
Data Validation==>Allow: List=> Source: $A$2:$A$10 (for example) .. first
row is a header

In E1:

=VLOOKUP(D1,$A$2:$C$10,2,0) .... gets first dimension

in F1:


=VLOOKUP(D1,$A$2:$C$10,3,0) .... gets second dimension

I have changed your ranges but hopefully you get the idea.

HTH
 
Top