Offer Sales Codes marking

Formula on f1 to drag down , those have marked manually against lookup table A

This being on a1
since I am failing to attach

CL504
CL507
CL509
CL516
CL521
CL553
CL555
CL620
CL663
CL673

This is on c d e f

13.01.2016 8931A2XL 1
13.01.2016 1402A2XL 1
13.01.2016 FL320RD39 1
13.01.2016 CL507C37 1 MARK
13.01.2016 CL507BR37 1 MARK
13.01.2016 CL730C36 1
13.01.2016 CL749C41 1
13.01.2016 CL516BR42 1 MARK
13.01.2016 CL749BG37 1
13.01.2016 CL705C41 1
13.01.2016 CL705RD41 1
13.01.2016 EV439BZ41 1
13.01.2016 CL504GR41 1 MARK
13.01.2016 LDWLT1550 1
13.01.2016 CV086GY41 1
13.01.2016 BAGCRL 1
13.01.2016 M54-1C44 1

Formula on F1 to drag down

Marking CL507C37 because it is on table column a as CL507

If column A's codes are always 5 characters, then simply:

Please Login or Register  to view this content.

Edit: Arggghhh.. he beat me again

and always with a prettier formula

Yes this will work , thank you very much all

I am sorted if 5 characters suppose one of them is at 6 characters then ?

Like this one

CL0418

situation to take both 5 characters and 6 characters

Try this:
=IFERROR(IF(MATCH(LEFT(D1,6),A:A,0),"MARK",""),IFERROR(IF(MATCH(LEFT(D1,5),A:A,0),"MARK",""),""))

Awesome Beamernsw , thank you very much