Dear all,

I am looking for an equivalent of the "EQUIV" function that would search not for an exact match but for a substring.

I use it in the following (in French) formula :

=INDIRECT(ADRESSE(LIGNE(C44);COLONNE(C44)+(ARRONDI.INF((EQUIV($D3;C65:BV65;0)-1)/4)*4)))

So, this function would have to return the index of the cell in the specified range containing the substring $D3.

Thanks in advance for your help !

Regards,