Conditional

[Juran]

I need to enter/scanning a series of serial number, but I
want to use a conditional or any other commend that tells
me that I enter the wrong serial number.

Ex.:

S/N TDI1132490
S/N JM5243850

I was trying to use contidional were if the S/N was TDI*
will the serial numbe and if it was diferent will write Error

Any Suggestion?

Thank you.

Juran

 

[JE McGimpsey]

One way:

=IF(LEFT(A1,3)="TDI",A1,"Error")

 

[Billy]

You can use command: Data|Validation|Settings and in Allow combo box
select "List". Then select valid entries you allow to be in the cell.
HTH
Billy

 

[Juran]

Thank you for your help.

What do you mean by LEFT(A1,3)? I am lost on "3".

Juran

 

[JE McGimpsey]

Did you look up "LEFT" in XL Help? It's got some pretty good examples.

 

[Herbert Seidenberg]

Billy:
How do you write the equivalent of "Three valid letters plus any
combination of seven digits" into your list?

 

[Billy]

For that type of validation you have to write all valid entries in the
worksheet cells. For example in block from A2:A10 and then for list you
show/point on that block. So then you can type or select from drowdown
combo box only values in that block you select.