Return non blank refrence from vlookup

[akhtaraijaz]

Hi,

I have a database with column A containing multple but repeated names,
Each name will have sigle Emp codo., I am trying to pull the emp code by name, but data base contains name multiple times and emp code only once, and if first occorance is blank then i get 0, please help,
=VLOOKUP(C2,A:B,2,0)

A B C D E
1 DJ
2 DJ
3 DJ 3
4 RJ
5 RJ 4
6 RJ

[NBVC]

Please post a better example, perhaps in an attached spreadsheet and show some expected results.