Hi,

The idea is that the person searching might not know all 5 items so they can put in some info and it will return a list with anything that is close to it but still based on the items they do know. I have attached another sheet to look at, at the top is where the user would type what they are looking for below that is what I want it to return and the last table is where the information is pulled from.

I have done 6 Examples using the same data but with different search criteria each time so you can see what the results should be.

Cheers

Mac

Attached Files

Book1.xlsx (16.2 KB, 12 views)