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