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 |
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 |
All times are GMT +1. The time now is 02:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com