Compare characters of two cells and return the result

**shahid6634** · 11-24-2012, 04:12 PM

I want to compare the two values of cells (which may number or character text) and returned the result as I required.

For example

If A1 cell value is http://shahid.com and A2 cell value is http://shahidxyz.com

Now my question is how to set formula in B1 cell to find http://shahid in A2 cell and return the result as "YES" in B1 cell if the value is found A2 cell otherwise "NO".

Your best regard will be thankful

**martindwilson** · 11-24-2012, 04:17 PM

you could try
=IF(ISNUMBER(FIND(LEFT(A1,FIND(".",A1)-1),A2)),"yes","no")

**shahid6634** · 11-26-2012, 08:25 AM

Thank you martindwilson

Now I want to look up http://shahid.com in the entire column A. How to create formula for this condition.
Please help me once again

**martindwilson** · 11-26-2012, 08:50 AM

what do you mean?

**shahid6634** · 11-27-2012, 08:41 AM

Suppose I have a list of 90 websites which is stored in Column A.
Now I discover another website (http://shahid.com) place in cell B1, but I want to check the availability of this site in list of 90 websites which is already store in column A.

How can I formulate this condition in cell C1. If, site found then show "YES" otherwise "NO"
This is my actual query. Please see in Image

check.jpg