How to enter a specified digits in a cell if another cell has a certain text

[shadab841]

Brand	Shipment Code
PH	7 digits
PC	8 digits

Okay!
PH and PC are two brands in my logistics organisation,
the thing is the shipment code of PH is 7 digits and PC is 8 digits
what I want is when i enter PH the shipment code should only be 7 digits if its more than that then it should display me an error!!
(May be this could be done through Data Validation)

Please help me if you can!

Thanks!

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B
1	Brand	Shipment Code
2	PH	1234567
3	PC	12345678
Work

Cells with Data Validation
Cell	Allow	Criteria
B2:B3	Custom	=IF(A2="PH",LEN(B2)=7,IF(A2="PC",LEN(B2)=8))

 

[shadab841]

It worked like a charm

Thank you so much bro it helped a lot.

what if i add one more brand and it has 10 digits, then what?
not necessary but just curious!!

 

[Fluff]

Just add another nested IF

 

[shadab841]

also when i paste a data in the cell the data validation doesn't works.

 

[Fluff]

Data validation only works when you manually enter a value.

 

[shadab841]

Data validation only works when you manually enter a value.

Ok here is another problem with that...

Suppose i first wrote in the cell PH and entered 7 digits

but when i changed from PH to PC in the other cell there is still 7 digits without displaying any error
does that mean i have to put data validation in the brand column also???

 

[shadab841]

BTW thanks a lot for helping me out!!

You're the pro!!!

 

[Fluff]

Data validation only works when you enter a value in that cell. If you change any other cell, or paste data it does not do anything.

 

[shadab841]

Data validation only works when you enter a value in that cell. If you change any other cell, or paste data it does not do anything.

So are there any other options for me ??