https://www.dropbox.com/s/0ulhnl1wd60qvgq/N Plain Disappearance_5JUL18.xlsx?dl=0Trying to match 4 variables, but receiving #NA . I've incrementally built formula, and three variables pulled in expected value. Adding of the 4th variable is apparently the issue, however it looks correct from what I'm seeing. Can someone please take a look and see if they can spot issue. Perhaps I need to switch out Match to a SumProduct function. If that is the case, please help me with that, as I've only done multi-matches in Excel. Thanks in advance.
=INDEX('CN IMP_EXP'!$A$2:$T$5290,MATCH(1,('CN IMP_EXP'!$F$2:$F$5290=Corn!B3)*('CN IMP_EXP'!$Q$2:$Q$5290=MID($I$2,4,15))*(RIGHT('CN IMP_EXP'!$C$2:$C$5290,3)=Corn!$C$2)*('CN IMP_EXP'!$B$2:$B$5290=VALUE(TRIM(CLEAN($B$1)))),0),20) + Ctrl Shift Enter for array
=INDEX('CN IMP_EXP'!$A$2:$T$5290,MATCH(1,('CN IMP_EXP'!$F$2:$F$5290=Corn!B3)*('CN IMP_EXP'!$Q$2:$Q$5290=MID($I$2,4,15))*(RIGHT('CN IMP_EXP'!$C$2:$C$5290,3)=Corn!$C$2)*('CN IMP_EXP'!$B$2:$B$5290=VALUE(TRIM(CLEAN($B$1)))),0),20) + Ctrl Shift Enter for array
