Forum Discussion
mohsin91santono-_-1220
Mar 27, 2019Copper Contributor
Return Common Row Number if Conditions Are Matched
Hello There, My attached image is self explanatory. I attach raw file too. TIA
- Mar 27, 2019
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.
mohsin91santono-_-1220
Mar 27, 2019Copper Contributor
Hi Sergei
Salute!!
You are awesome :D
Salute!!
You are awesome :D
SergeiBaklan
Mar 27, 2019MVP
mohsin91santono-_-1220 , glad to help