Hello,
I am trying to do a simple index-match formula, and for whatever reason, it does not work when it has many times in the past. I even tried putting quotation marks around the 'OMB' sheets, and it's still failing. Please help!
=INDEX(OMB!$E:$E,MATCH(1,(OMB!$C:$C=Sheet3!$A2)*(OMB!$D:$D=Sheet3!B$1),0))
Bookmarks