Hi Guys,
I have a formula that I have been using to Index/Match with 3 column based criteria. I am looking to alter it so it is NOT an array formula. As I sort/adjust criteria it is screwing up. Anything I can do so it is just a sitting formula, NOT array.
Thanks a lot!
![]()
{=IFERROR(INDEX(MILL!D:D,MATCH(1,('2018'!$F11=MILL!$A:$A)*('2018'!$C11=MILL!$B:$B)*('2018'!$J$9=MILL!$C:$C),0)),"-")}
Bookmarks