Hi Guys,

I really need some help to sort this out.
I have a data report, with a lot of information. The report shows me data: part number, serial number, and workorder+line number.

I want to create an input-database, actucally.

I'd like to have it this way: open the excel file, insert updated versions of resources reports in to the multiple sheets of the workbook, and have excel find everything about the items i am looking for in multiple resources, and displaying these all (types of results in a different column each). This will then give me a detailed overview of possible statusses.

I need to have a workbook, wherein in can paste in sheet one: the part number, serial number workorder+line numbers. (a fixed field would be perfect).

Then I want excel to start looking in other sheets which I can add-in on the next worksheets.

I have the following data files, I hope it is clear what I want now.

If excel starts searching, I want it to display the results in the (main/first) sheet of the workbook, behind my input(s).

Conditions are:


Using a VLOOKUP, have Excel looking for an exact match of the serial number result in column E to be displayed.

using a VLOOKUP, looking for an exact match of the workorder+line number
(in the resources sheets), result in column F to be displayed.

When Excel has not found any perfect matches, I want Excel to search the same files with some "conditioned" rules.

I want Excel to search for a non-exact match, like when for example the serial number i am looking for is: 001122334455, I want excel to look for *22334455*. This result to be displayed in Column G.

I want Excel to search for a non-exact match, like when for example the serial number i am looking for is: 001122334455, I want excel to look for *223344*. This result to be displayed in Column H.

Is this possible to create?
I will post the files and data a little later this week, I hope there is a solution/possibility to achieve what I want.