Vlookup would require the "key" or lookup value to be on the left side of
the table/array (left most column), in your case, the Account #. Look to use
the LOOKUP function.

"PrincessM" <u22004@uwe wrote in message news:60722cbe825c2@uwe...
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