Lookup based on check box

[David W 123]

Hello!

I have a database listing 150+ countries and their geographical habitats (cells A1:H6 as an example).

I would like to have a check box look up (cells A9:B15) and depending on selection choice the output would list all countries that match the criteria (Australia and Ethiopia in the example). Depending on how many boxes are ticked, the number of countries returned could be between 1 and perhaps 100 in number, ideally listed in a nicely formatted list.

Is this even possible?!?

Many thanks in advance for your time / support!

David

 

[C Moore]

What do you need to do with the list? If its just for reference, add a column next to snow "Meets Criteria" that will return TRUE if all conditions are met. Format as table and then filter by TRUE. Are your checkboxes linked to a cell? For example the city checkbox can be linked to B9, which gives you the comparison for the city column.

 

[C Moore]

Uses true or false instead of y and n
conditions met formula

=SUMPRODUCT((checkboxcells=TRUE)*(Table5[@[City]:[Snow]]=TRUE))=COUNTIF(checkboxcells,TRUE)