Hello everybody
I have a formula that allows me to search results from a list of values with two search criteria. i need to be able to add one more criteria: 3 search criteria in total. I tried it but somehow can't get the syntax right.
It is important that the formula retrieves several results if more than 1 are present, just like it does now.
Attached is the document with the 2 search criteria formula in range B8:B14
Search criteria are in cells C4, C5 in sheet "acces point sensorik"
The data is in the sheet "datenbank sensorik"
Thanx in advance for your help
Greetings
Bookmarks