how do I enter this formula? I was trying to edit it and then drag the formula across, but it doesn't return the same values as are in the cells. Sorry for the stupid question. Also, I switched the selection from New to Old and it returned both of the rows for OLD but it shouldnt' do that.
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...