VLook-Up Match first 3 characters of one cell with another column

[Kulsumbi]

Serial #	Result		Townid	MyUniq
123566			123	1111
123456			276	2222
276455			456	3333
276456			789	4444
456778			000	5555

I want to match first 3 letters of "serial #" against "town ID's" if it matches then "myuniq id" must fill in the result cell.


Please assist

 

[sandy666]

You are welcome