IF for string

[D_N_L]

Hi,

I'm looking for a formula which looks at cell A1 and if it contains the exact text that is in B1 returns 'Yes' and if it doesn't it returns nothing.

Thanks

[NBVC]

By exact do you mean case sensitive?

If yes, then:"

=IF(EXACT(A1,A2),"Yes","")

If no, then

=IF(A1=A2,"Yes","")

[dilipandey]

Hi Plumby,

Use following formula:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps >

[tom1977]

=IF(A1=B1,"yes","") ???

[D_N_L]

Thanks everyone. I needed the EXACT feature. Thanks!