Auto complete the next cell after inputted a text

I'm currently working with my research about company listed in Indonesian Stock Exchange, I need a formula that will Auto input the next cell after i inputted a text in a cell before it in the same row... This sounds like a little bit complicated because my limited english ability, but heres my data sample looks like...

A1
MAYA
MCOR
MEGA
NISP
PNBN
SDRA
AGRO

B1
Bank Mayapada Internasional Tbk
Bank Windu Kentjana International Tbk Tbk
Bank Mega Tbk
Bank OCBC NISP Tbk Tbk
Bank Pan Indonesia Tbk
Bank Himpunan Saudara 1906 Tbk
Bank Agroniaga Tbk


The problem are, i need to everytime I enter "MAYA" in the other worksheet or other row, then the cell next to it will automatically filled with "Bank Mayapada Internasional Tbk", this will save many hours of copy paste

any help will be greatly appreciated...

below you will find my workbook example...

Sample Bank.xlsx

oeldere? where have you gone

Originally Posted by oeldere

Please Login or Register  to view this content.

???

Is there any way that the abbreviation can be entered manually rather than picking it up through a drop down list? because there's a large data i supposed to enter, and it will be pain to picking it through a drop down...

thanks for the reply

No its not working... i cleared the data validation in the A column, and now everytime i type in A column, it will immediately turn to the full name of the bank, and the C column shown up as #N/A... perhaps we should adjust the formula?