Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Validate field
How I do to validate one field with condicional function? I am doing it.
Made one matrix call Brand and others call Model_A, Model_B, Model_C... I n Brand I put, for example, ADC, Belden, Sony, Toshiba ... In the others, for example Model_ADC, I put the all models reference the ADC Brand, and I repeat this operation for next matrix. Now I create one cell with validade Brand with suspense list. It is OK. (data-validade-list-font (=Brand). After I create one cell with condicional validade. It is Ok. (data-validade-list-font =SE(E15="ADC";Model_ADC;SE(E15="Belden";Model_Beld en;FALSO)). The problems is that the field font accept just only 255 word and my data is bigger. Someone knows what to do it? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Validate field
I'm not absolutly clear on your request, but I think your solution is not to
use a complex IF statement in the data validation area. Instead: 1. Set up one range where the Brands are listed. For example suppose the brands Toshiba and IBM are listed in cell A1:A2. 2. Set up separate ranges for each brand listing their models. For example in cells D1:D2 enter the IBM models, say Thinkpad, Servers. Name the range D1:D2 IBM. In F1:F2 enter the Toshiba models, say Satelitte Notebook, HDTV. Name the range F1:F2 Toshiba. (Name a range by selecting it and choosing the command Insert, Name, Define and typing the name into the Names in workbook box.) Select the range where you want the user to pick the brand from. Say M1:M10. Choose Data, Validation, List, pick the source range A1:A2. Select the range where you want the user to pick the models from. Say N1:N10. Choose Data, Validation, List and enter the formula =INDIRECT(M1). (respond OK to the message) Now when the user picks a Brand in column M and then moves to column N, the pick list will show the items for the appropriate brand. -- Cheers, Shane Devenshire "caue_franzon" wrote: How I do to validate one field with condicional function? I am doing it. Made one matrix call Brand and others call Model_A, Model_B, Model_C... I n Brand I put, for example, ADC, Belden, Sony, Toshiba ... In the others, for example Model_ADC, I put the all models reference the ADC Brand, and I repeat this operation for next matrix. Now I create one cell with validade Brand with suspense list. It is OK. (data-validade-list-font (=Brand). After I create one cell with condicional validade. It is Ok. (data-validade-list-font =SE(E15="ADC";Model_ADC;SE(E15="Belden";Model_Beld en;FALSO)). The problems is that the field font accept just only 255 word and my data is bigger. Someone knows what to do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
Search and Validate | Excel Discussion (Misc queries) | |||
Validate a result | Excel Discussion (Misc queries) | |||
How to validate | Excel Worksheet Functions |