Hi,

I have a spreadsheet with over 20,000 rows. From another spreadsheet I need to find if any of a list of 90 customers are within the first, using a simple IF and vlookup formula which comes back yes or no.

I am using: =IF(A2 = VLOOKUP(A2,ihcust!B:B,1),"YES","NO")

However, although this works when they are spelt exact in both sheets if they are not it will say no.
eg. If I was Looking up "Joe's Icecreams" from the list of 90 but in the other sheet it is listed as "Joe's Icecreams (admin)" it would not recognise it and come back no.

Is there away to get around this problem?

Thanks in advance for any help.