Search Excel file

[Ildestino]

Dear Gurus,

I am trying to build a search excel file. This file should search for descriptions into 3 different excel files and show users the results.

The constellation of files are:

Material List: Descriptions are in column "O"
Equipment List: Descriptions are in column "C"
Vendor List: Descriptions are in column "G"

The master excel file should contain 2 fields for searching

Field 1: Name/Description
Field 2: Dropdown list of Material, Equipment and Vendor.

If the search comes up with a result, it should show the whole row.

I hope you guys can help me out.

Many thanks in advance.

Kind regards

Il

[snb]

Integrate 3 Excelfiles into 1 (containing several worksheets) first.

[Ildestino]

and then?

[snb]

Post you sample workbook here and indicate very clearly what you want to accomplish.