Hi there,
I work in the mobile industry running campaigns and so forth. We received
the sms entry report in a excel spreadsheet.
What I need to do is find the region of entrants. The Entry Data report has
the date, Cell number and text which was entered across columns. The Text
that they have entered will have their City or region in it eg. "Hi I live in
Cape Town"
We'll say that his text is in A2:A100
What I did was, I created a table of Cities of South Africa and in which
province they are in.
We'll say the the City is on Sheet [City] A2:A100 and the Province is on
Sheet [City] B2:B100.
I need to match the name of the city found in the entry text to the name of
the city in the table that I have created and the result should be the
province.
Can this be done ?