Search and Replace with twist

[wsperry]

hello,
I am looking for a way to search and replace but replace the original cell with the value that it finds. I have two columns with city names in them, but one column has aggregated values (newyork-newjersey) and the other has single name cities in them only. Is there a way to systematically select a cell in the smaller name column, search for that name in the bigger column, and then replace the original smaller name cell with the total cell it finds? For example, select newyork cell, search for newyork in the other column, find a cell that contains newyork-newjersey, and replace newyork cell with newyork-newjersey. (then move down and do this for every cell in the smaller column)? My underlying problem is that the cities are not recorded in the same way which makes statistical analysis impossible.
Thanks for any help!

 

[hiker95]

wsperry,

Welcome to the MrExcel forum.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com