Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple combo box problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple combo box problem
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 "JonathanW" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple IF problem | Excel Discussion (Misc queries) | |||
Simple problem | New Users to Excel | |||
Simple problem I'm sure | New Users to Excel | |||
Combo Box problem | Excel Discussion (Misc queries) | |||
another simple problem... | Excel Worksheet Functions |