String Compare Between 2 Lists or Reference

[junkie]

I have a list of text names in 'WS2'!AC3:AC200 EXAMPLE
ABC Vegitation Control Service Ltd (AC3)

I want to lookup to see if this string exists in 'WS1'!A2:A60
containing another list of text names EX
ABC Vegitation Control Service Ltd

if this is tru I want to label a cell in WS2 where I am doing thi
lookup up with "E". I have tried the following but nothing has worked
=IF(COUNTIF(AC3,WS1!B2:B669)>1, "E", "")
=VLOOKUP(AC3,WS!$B$2:$C$669,1,0)
=MATCH(AC3,WS1!$B$2:$B$669,0)
=IF(MATCH(AC3,WS1!$B$2:$B$669,0), "E","")

I know for a fact that ABC Vegitation Control Service Ltd exists in th
list in WS1 but it returns false for all of the above.

Any suggestions???

Regards,
junki

 

[junkie]

SORRY MATTER resolved those formulas work but the spelling wa
different

Vegetation VS
Vegitiation

arghhhhhhhhhhhhhhhhh

thx,
junki

 

[Frank Kabel]

Hi
o.k. the first formula should read
=IF(COUNTIF(WS1!B2:B669,AC3)>=1, "E", "")
though the remaining three should return something. Are you sure, the
strings a identical. that is AC3 is not only a part of your lookup
range

Frank

 

[junkie]

Thx for reply Frank.

Best Regards,
-Junki