"KKPeters" wrote:
I am afraid I was not clear. I am looking to pull all the Cities that does
not match the cities in the range - so I am still working with text.

Here's a simpler alternative using Autofilter on a helper col
which can achieve the same objectives

Suppose you have a defined range
MyCities =Sheet2!$A$1:$A$20
which lists all "your" cities

In any other sheet,
Assume you have cities listed in B2 down
Put in C2: =IF(B2="","",ISNUMBER(MATCH(B2,MyCities,0)))
Copy C2 down all the way, then just autofilter col C for FALSE to gather all
the lines with cities that do not match those within MyCities (TRUE would be
those lines that match)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---