In this case the limitation may be in the layout, not on the column names.
The VLOOKUP formula looks at a column and return other columns on the right
of it, so in your case you will only be able to retrieve "Branch" and
"Address" with the formula.
With the example, if you have 100 rows of data, and the A/C to look is on
cell F1, you can use VLOOKUP this way:
Branch: =VLOOKUP(F1,$C$2:$E$100,2,FALSE)
Address: =VLOOKUP(F1,$C$2:$E$100,3,FALSE)
If you can move the A/C column to the column A you can retrieve all the
information, changing the range to $A100:$E100 third parameter to the column
desired (2 for column B, 3 for column C and so on)

Hope this helps,
Miguel.

"PrincessM" wrote:

i have a master data like this.
A B C D
E
Customer Bank Bank A/C No. Branch Address

and on the second sheet, i would like to just enter the Bank a/c on the first
col, and the details will come out.

Please help me on how to do that. I understand that i need to have the same
coloumn name and stuffs like that, right?

Thanks in advance.

Regards,
Merlina