Mar 27 2019 12:40 AM
Solution
It could be
=IFERROR(MATCH(1,INDEX(ISNUMBER(SEARCH($J$14,$A:$A))*($H:$H=$K$14),0),0),"no such")
Please see in attached file.
Mar 27 2019 12:43 AM
Mar 27 2019 12:43 AM
Mar 27 2019 12:45 AM
Mar 27 2019 12:58 AM
@mohsin91santono-_-1220 , glad to help
Mar 27 2019 12:40 AM
Solution
It could be
=IFERROR(MATCH(1,INDEX(ISNUMBER(SEARCH($J$14,$A:$A))*($H:$H=$K$14),0),0),"no such")
Please see in attached file.