IF Contains instead of = in Array formula

Hi everyone!

Ive been trying to change the following the formula from


IF Database!$I$4:$I$1200 IS EQUAL TO $L$3, ROW[…]

to

IF Database!$I$4:$I$1200 CONTAINS $L$3, ROW[…]

I tried the search formula in vain. Please find below overall formula:

Please Login or Register  to view this content.

Thanks to any help which would be much appreciated!!

Kind Rgds,

Brian

I might be missing something but the formula seems complicated

match("*"&$l$3&"*",Database!$I$4:$I$1200,0) will return you the rownumber can this not be incorporated in a normal formula

say if(isnumber(match("*"&$l$3&"*",Database!$I$4:$I$1200,0)),match("*"&$l$3&"*",Database!$I$4:$I$1200,0) etc ,whatever )

Hi, try

Please Login or Register  to view this content.

Regards.