Hi I need additional criteria for this formula
=IFERROR(INDEX(Committee!$D$2:$D$38;MATCH($B3&"^"&P$2&"^"&$D3;INDEX(Committee!$A$2:$A$38&"^"&Committee!$B$2:$B$38&"^"&Committee!$C$2:$C$38;0);0));"")
which is if cell does not match Committee!$A$2:$A$38&"^"&Committee!$B$2:$B$38&"^"&Committee!$C$2:$C$38 to return to x. Please see attached document. Thank you.
Bookmarks