String Compare Between 2 Lists or Reference

  • Thread starter Thread starter junkie
  • Start date Start date
J

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
 
SORRY MATTER resolved those formulas work but the spelling wa
different

Vegetation VS
Vegitiation

arghhhhhhhhhhhhhhhhh

thx,
junki
 
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
 
Back
Top