Hello,

I'm trying to have a formula give me a result for two criteria. I've evaluated the formula, and there's clearly something wrong with my match (Both show as 0s, so something isn't matching up, not sure why though.. I'll attach the files if I need to, but for now at least, I want to make sure the formula is okay.

Formula: copy to clipboard
=INDEX('[WO to SKU - Copy.xlsx]WO to SKU'!$B:$F, MATCH(1, ($B$12='[WO to SKU - Copy.xlsx]WO to SKU'!$C:$C) * ($B$10='[WO to SKU - Copy.xlsx]WO to SKU'!$F:$F),0),1)