matching numbers with different digits orders

Correction...

=IF((SUMPRODUCT(--ISNUMBER(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),B1)))=LEN(B1))*(LEN(A1)=LEN(B1)),C1,#N/A)

Hope this helps!

Originally Posted by Domenic

Try...

D1, copied down:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),B1)))=LEN(B1),C1,#N/A)

Hope this helps!