Using Vlookup for duplicated numbers

Hi everyone,

I am trying to vlookup the numbers in column titled branch to return same for cif but excel is returning the first cif number where the branch numbers are duplicated as follows:

Branch Cif Excel Results (Cif)
304620 308203 308203
304620 308055 308203
304620 306207 308203
452546 228901 228901
305552 302398 302398
305552 181381 302398
305239 306863 306863

Please what logical formulas can i use to get around this lack of unique numbers.

Many thanks for you assistance.

Folarin