Forum Discussion

mohsin91santono-_-1220

Copper Contributor

Mar 27, 2019

Solved

Return Common Row Number if Conditions Are Matched

Hello There, My attached image is self explanatory. I attach raw file too. TIA

FL'19 Check list.xlsx11 KB

SergeiBaklan
Mar 27, 2019
Hi mohsin91santono-_-1220 ,

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.
FL'19 Check list.xlsx12 KB

Silver Contributor

Mar 27, 2019

The formula in L14 is:
=MAX(INDEX(ROW(A2:A5)*
ISNUMBER(FIND(J14,A2:A5))*
COUNTIF(K14,H2:H5),0))

Resources