Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating entry using validation
I have two columns e.g. - fruit, code
apples, 01 oranges 02 lemons 03 On my form the cell for apples is a validation list cell and I would like the cell for the code to appear in another cell automatically. I like validation rather than a drop-down combo box because the "box" isn't seen until the cursor is in that cell and doesn't print. Can both cells be validation with the proper function in the appropriate cell? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating entry using validation
Dianna,
You could put a formula into the code cell. Either an If..then..else or a Vlookup (if there are a lot of "fruit") In both cases use a multi-level If statement. For example - if the fruit is in A1 and the code is in B1 and your table is in D1:E5 =If(A1, Vlookup(A1,D1:E5,2),"") The "" will leave B1 blank if no choice is made. Beware that no match will result in #NA. You can trap for this in your formula, but since you are using a Validation list, it shouldn't be an issue. -- sb "Dianna" wrote in message ... I have two columns e.g. - fruit, code apples, 01 oranges 02 lemons 03 On my form the cell for apples is a validation list cell and I would like the cell for the code to appear in another cell automatically. I like validation rather than a drop-down combo box because the "box" isn't seen until the cursor is in that cell and doesn't print. Can both cells be validation with the proper function in the appropriate cell? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating entry using validation
Thanks Steve, I will give it a try when I get a chance...
-----Original Message----- Dianna, You could put a formula into the code cell. Either an If..then..else or a Vlookup (if there are a lot of "fruit") In both cases use a multi-level If statement. For example - if the fruit is in A1 and the code is in B1 and your table is in D1:E5 =If(A1, Vlookup(A1,D1:E5,2),"") The "" will leave B1 blank if no choice is made. Beware that no match will result in #NA. You can trap for this in your formula, but since you are using a Validation list, it shouldn't be an issue. -- sb "Dianna" wrote in message ... I have two columns e.g. - fruit, code apples, 01 oranges 02 lemons 03 On my form the cell for apples is a validation list cell and I would like the cell for the code to appear in another cell automatically. I like validation rather than a drop-down combo box because the "box" isn't seen until the cursor is in that cell and doesn't print. Can both cells be validation with the proper function in the appropriate cell? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry + Validation | Excel Discussion (Misc queries) | |||
Automating to autofill column B based on column A entry | Excel Discussion (Misc queries) | |||
Automating Address Information based on selecting data via a validation list | Excel Worksheet Functions | |||
Automating entry in a cell | Excel Worksheet Functions | |||
Can I pick more than 1 entry in the validation function? | Excel Worksheet Functions |