I've been trying to get a formula to return all rows from a tab in which multiple criteria are met, including a wildcard criteria. I've attached the sample excel in terms of what I'm trying to achieve. It's very basic and not the actual dataset, but you get the idea. I can get it when the cells are exact matches, but not if the cell contains it.
Please help if you can and thanks.
Please help if you can and thanks.