I have a Table of CITY , When I go for match function I had to write some times 4 cities names, some times 6 cities name, what I am facing is I write again and again city names regarding different criterias, Is it possible that I bring a Field in the Match fucntion in which that particular fields contains all the city name and should match them on conditions, as such there would be no need for writng city names again and again. I mean I dont want to write city names in Match function again and again I just need a Field which should fetch city names and go for matching in Match function. For example it takes log if I have to write 25 city names, is there any simple solution that city be fetched in Match function without writing them again and again.
CITY:
London
New York
Maxico
and so on all the cities upto 100.
if (Match (City, 'London', 'New York', 'Maxico','Karachi','Mumbai')) as XYZ
in upper case I had to write all the names depending condition.
