Tried ISNUMBER suggestion; and it did not work.

It should have, as-in ISNUMBER is the "reverse"
that you mentioned you wanted for your expression which worked:

=ISNA(MATCH('Wrong Vendor'!$H$2,FedEx!$I$1:$I$312,0))
I need the reverse of this ..

so, perhaps it's a problem with your data, or something else

Maybe try Debra's page at:
http://www.contextures.com/xladvfilter02.html

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KKPeters" wrote in message
...
Tried ISNUMBER suggestion; and it did not work. There may be a CITY name
(or
ZIPCODE) but it will not be in my list of store. What I need is that if
the
City is not in the list that it will show up using the Advance Filter
Criteria. I need to isolate the shipments that are not going to any of my
stores.

Thanks, Krystal Peters