Dear Experts
Kindly review this below formula and please let me know what's gone wrong.The same formula is working fine in some sheet but not in all sheet. Please guide me (all sheet consist of same kind of value)
=IF($H5="","",SUMPRODUCT((ISNUMBER(SEARCH(INDIRECT("'"&$A$1&"'!"&"$H5"),INDIRECT("'"&$A$1&"'!"&"$C$4:$C$2000"))))*(INDIRECT("'"&$A$1&"'!"&"$A$4:$A$2000")=J$3)*(INDIRECT("'"&$A$1&"'!"&"$D$4:$D$2000"))))
Bookmarks