Forum Discussion
Solved
Return Common Row Number if Conditions Are Matched
Hello There, My attached image is self explanatory. I attach raw file too. TIA
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.
This array formula (enter formula using control+shift+enter) does the trick:
=MATCH("*"&J14&"*|"&K14,$A$2:$A$5&"|"&$H$2:$H$5,0)
Note the * wildcard characters enabling the code to be found in any part of the cells of column A
=MATCH("*"&J14&"*|"&K14,$A$2:$A$5&"|"&$H$2:$H$5,0)
Note the * wildcard characters enabling the code to be found in any part of the cells of column A