Matching inverted values (easy)

Why is H5 not OxfordMoscow?

Do you have a list of cities so that a function would have a chance of determining where the strings should be split?

If I understand well you want compare two cols and show result in third col. Try this (change references suitable):

Formula:

Please Login or Register  to view this content.

confirmed by CSE
Maybe it is long but have no more time, sorry

@Nickopopolo

Is this the same question als asked in this treat?

http://www.excelforum.com/showthread...t=#post4394067

Originally Posted by Nickopopolo

Richard Buttrey, there no OxfordMoscow in Row2 hence, I assume, that the function won't be able to find any values for it when matching.

Do not really understand what you mean by list of cities?

I didn't mention row 2. I was asking about H5.

You appear to want the column A values 'reversed. So the results in G1:G5 are your original A1:A5, and H2:H4 take the G1:G4 values and swap the cities around. H5 though is different, in fact its empty and I was asking why since it's not consistent.

I asked whether there was a separate list of cities so that the first few characters in each cell could be checked against this master list of cities to see if there is a city that matches those characters. This would be useful in helping determine where the city/city string should be split.