Hi guys

I am trying to create a database in which one can look up one of two values (Could be more). Meaning that if you type in a value, it's corresponding counterpart follows as a search result. I have data stored which have duplicate values meaning the same thing. E.q. Vendor A sells an item under one part name (ItemA) and vendor B sells another under another name (ItemB). The two products are completely identical. But in my database, the same product now have two separate item-names.

Those specific values can be stored in a varying number of sheets, so the code must be able to search through all the sheets, and only return unique hits.

Can one of you tell me a code that will allow me to type in either one of the two item-names and then return the same value from the vendor which product I did NOT search for?

It is basically a database which will ensure that I don't have to go look for that other product name, because I may already have it.

I have included a sample workbook for you to look at. I would like the search engine to function from a separate sheet. SampleWorkbook1.xlsx