Fill a column based on another corresponding cell or serial numbers

Column A has Serial numbers and Column B has Bank names. In C Column I need to fill the matching bank names of corresponding serial numbers. How to do this.

Please try at C2
=INDEX($B$2:$B$13,MATCH(1,($A$2:$A$13=A2)*($B$2:$B$13<>""),0))

or

=LOOKUP(1,1/($A$2:$A$13=A2)/($B$2:$B$13<>""),$C$2:$C$13)

Originally Posted by Bo_Ry

Please try at C2
=INDEX($B$2:$B$13,MATCH(1,($A$2:$A$13=A2)*($B$2:$B$13<>""),0))

or

=LOOKUP(1,1/($A$2:$A$13=A2)/($B$2:$B$13<>""),$C$2:$C$13)

tHANKS A LOT. it did.

Originally Posted by Bo_Ry

Please try at C2
=INDEX($B$2:$B$13,MATCH(1,($A$2:$A$13=A2)*($B$2:$B$13<>""),0))

or

=LOOKUP(1,1/($A$2:$A$13=A2)/($B$2:$B$13<>""),$C$2:$C$13)

thank you very much for time. it solved.