It depends on how your data is set up in workbook2, but Vlookup would be the
most popular choice.

If you need more help, post back with the organization of the data in
workbook2.

Regards,
Fred.

"Ajit Munj" wrote in message
...
In workbook1, I have various bank's 7 digit codes (e.g.00023010, 0102045
etc.), but not bank's name. For that I have separate excel workbook2 with
Bank's branch address with its codes. I want that banks' name & address
beside the cell corresponding to it's code in workbook1. How can I do the
same?
--
Knowldege is Power