Lookup with if Function

[nicci113]

Hi There,

It seem easy at first but I can't think of another way and needa bit of direction.

I have series of UK registered vehicle, I need to identify the new and old i.e. Any vehicle registered before 2000 is old everything else is New, Since the format changed at 2000, I can get unique values.. Please help!

QW50QWE - NEW
q234REW- OLd.

 

[Special-K99]

Based on your (extremely limited) data the pattern seems to be if the second character is a number then it's old else it's new.
So this should work

=IF(ISNUMBER(MID(A2,2,1)+0),"Old","New")

 

[nicci113]

Thanks Works fine and sorry for less data but the pattern is same. Can you please let me know why you put +0? Is it to check if the number can be added to the value if not its "old"
"

 

[Special-K99]

+0 coerces the result into a number as it's actually text. It may look like "2" in your second example but it's actually text so the ISNUMBER() will fail without +0

 

[nicci113]

Thanks pal really apperciate your help!