Excel97: Find data in an independant she

Okay, before I start explaining, and you start thinking the same as me : I know this would be a lot easier if I could just use Access for this… Unfortunately, the user does not have Access installed, and doesn’t want to either. So I need to find away to do this in Excel.

There is an Excel file which contains a list of products, and its specifications (product nr, product name, price a piece, …). There are several (1 per client) excel files which contain 1 or more invoices. In column A he would enter a product nr, and then the user wants the other specifications (name, price) to appear in column B and C.

I truly would appreciate if someone could help me out on this one…

Sabrina