Return multiple results based on multi-criteria selection

Hi everyone,
I've used a code found in another post in order to create an item selector based on a number of criteria.
Each cell which is filled in is supposed to look in another sheet and return a number of possible options as a result in one unique cell.

My problem is that not all possible results show up in the destination cell, as it seems that the returned value is the 1st one found and then the search stops. Furthermore, I have the feeling that at some stage the search is not on anymore, as some search fields don't seem to be taken into account (C14:C19)

I've attached the file and would very much appreciate any help I can get in order to understand what I'm doing wrong.
Many thanks,

Please Login or Register  to view this content.

Yes, the sensors do come into the equation, but in fact the returned result must be basis all results of the filled cells.

The thing is, maybe not all cells will be filled in, so the result must be calculated only basis the "true" values. I'm not sure that explanation is very clear... In fact, I want to match all filled in values, however many there are

Brilliant, that seems to work just fine !

I'm now going to have to read through your new code to try to understand it !

Mumps1, you've been a fantastic help, I much appreciate it !
Many many thanks indeed

Hi Mumps1,

There seems to be an issue :

In C2/C3/C4 and in C19 of the SELECTOR worksheet, whilst the SOURCE data seems to be identifed, the returned result in E10 seems to be "erased" and *No matches* shows up. I say that the data is identified, because it shows up for a fraction of a second and then disappears.
I've identified working and non-working cells in column F of the SELECTOR sheet.
I'm attaching the file.
Thanks again for your help.

Brilliant, that works a treat !

Again, many many thanks Mumps1.

i'll set the status of the post to SOLVED.

OK, I seem to have an issue with the code.

What I think happens I see that the “form” does not reset. Hence after using it a few times, then result ends up by showing *no matches*.

Does anyone know how to include some sort of reset button or code to ensure that’s this keeps working ?

Many thanks to anyone out there who’ll be able to help.

Hi Mumps,

What I mean is that it does not provide the same results basis same data input. It looks like once you've made a few selections, then it gets confused and does not provide results it should. I forwarded the file to 2 people for testing. When they opened it first time, it worked a treat, then after about 20 minutes testing, when it should have given some positive results, the *no matches* showed up, but did so just after the yellow "positive" result showed up for a fraction of a second.
It's very bizarre, becaus eit seems the macro runs, finds a result, and then returns a negative result. But it only does so for part of the selection.

C4 & C10 are both set to "YES" => No matches
C4 set to "YES" => No matches

Yes, all other cells are blank and I get "no matches".

However, before E10 displays "no matches", for a split second, it shows results and then they disappear and "no matches" up.

Ok, thanks. I'll test again and let you know if any issue.