Validate field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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_Belden;FALSO)).

The problems is that the field font accept just only 255 word and my data is
bigger.

Someone knows what to do it?
 
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.
 
Back
Top