If Statement challange

[pipshelton]

Hi I have a column in Excel which contains multiple post codes, I would like to in the adjacent column insert a different string dependant on the content within the original cell. For example the text could be M19, OL1 etc in the adjacent cell I would like it to display for M19 - East Manchester and for OL1 Oldham.

[Special-K]

You're best bet is to post a file else all we have to go on is 1 example.

Just post the postcodes, DO NOT post a file containing complete addresses, names etc
Maybe just copy the postcode column into a new spreadsheet along with how you want to see the results.

[LokeshKumar]

I guess without looking at data this is not possible.... Need to find out the trend in data.....

[greatjobtoday]

Do you have another table that contains the mapping file of zip to city? If you do, you could concatenate the zip using a vlookup based on a master mapping table with all of your possible city/zip combinations.

eg.

If your zip is in column A and you want the output in column B, put a table in Column D and E. D = zip code, E = city. (or in another sheet/workbook)

Once the table is setup, you can use this formula in column B

=A1&" - "&VLOOKUP(A1,D:E,2,0)

You will have to list out the cities for each zip code, but once you have the master table you can use the table for future zip code look-ups.

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Also, it would help if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.