Thanks for your reply Cresta, I tried yo formula but it didn't work.
You the problem comes in where it is not only the City that will be in a
cell but a string eg. Hi I live in Pretoria. I need to know how I can search
that cell for the city that matches in the table on the City sheet rang
A2:A100 and the results is the corresponding value in sheet [City] B2:B100.

Hope that makes some sense.

"Cresta" wrote:

use the following function

=index(array,,column_num)




"Roseygains" wrote:

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.
What I did was, I created a table of Cities of South Africa and in which
province they are in.
I need to match the name of the city found in the entry text to the nam of
the city in the table that I have created and the result should be the
province.
Can this be done ?