Ryan- Validation Question

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

Guest

"This validates the values before the 8-part model number is created. Is
that what you're looking for? Or do you need to further validate the
resulting combination against a list of model numbers? "

I need to further validate the resulting combination against a list of model
numbers. Any help?
 
Create a list of valid model numbers ... say in Column A of Sheet3 ... and
then validate using:

=if(ISNA(Match(B2,Sheet3!A:A,0)),"Invalid Model number","")

B2 contains model number


If you place this formula in adjacent cell e.g. C2, then message "Invalid
Model number" will appear if the entry in B2 is not found in column A of
Sheet3; if model is valid, no message is produced.

Is this an exceptable solution?
 
Thanks very much. Huge help

Toppers said:
Create a list of valid model numbers ... say in Column A of Sheet3 ... and
then validate using:

=if(ISNA(Match(B2,Sheet3!A:A,0)),"Invalid Model number","")

B2 contains model number


If you place this formula in adjacent cell e.g. C2, then message "Invalid
Model number" will appear if the entry in B2 is not found in column A of
Sheet3; if model is valid, no message is produced.

Is this an exceptable solution?
Click to expand...
 
Back
Top