R
ries
I need to validate a field with a different list or set of rule
depending on the previous field which has a vlookup value on. th
previous field is decided on a vlookup on product code it can chang
each time a new product code is chosen. I need to populate the nex
field with a value dependant on what the previous field value is an
with a validation rule, it is not always list some times can be tex
that is entered which also needs a rule. for one order code the valu
of the first field could be extension but for the next order code i
would populate the same field with cable so the field that needs
vlookup and a validation rule would be different each time.. sorry no
too good at explaining this but please help!
depending on the previous field which has a vlookup value on. th
previous field is decided on a vlookup on product code it can chang
each time a new product code is chosen. I need to populate the nex
field with a value dependant on what the previous field value is an
with a validation rule, it is not always list some times can be tex
that is entered which also needs a rule. for one order code the valu
of the first field could be extension but for the next order code i
would populate the same field with cable so the field that needs
vlookup and a validation rule would be different each time.. sorry no
too good at explaining this but please help!