VlookUp between two workbook

[yjmmay34]

Hi, all. I want to find No. in the DataBase file and put the no. to the File1 based on the name which contains several sheets. I thought this could be done by using VLookUp. But dont know how to make it happen. Please check the attachment below.
Thank you very much!

[henrikoz]

Hi!

See example, I must have missed something you want to do?

/henrikoz

[yjmmay34]

Thank you henrikoz ! But i need the macro to run the program. If you have time please check the link, i have change the database format, there are two sheets in the database. http://www.excelforum.com/excel-prog...nt-sheets.html