Hi!

I have 2 columns containing data: Column A contains location names, and Column B contains corresponding location data.

For example:
Column A
Bartlett, IL, Illinois - United States
Bel Air, MD, Maryland - United States
Bellevue, WA, Washington - United States
... (hundreds of locations)

Column B
156890
189234
780123
... (hundreds of codes)

Then what I hope to be able to do (not just once, but repeatedly) is this:

I paste some locations (10-25 locations) into another column, say Column C, of the spreadsheet. The formatting of the locations may be slightly different though:

Column C
United States,CA,Encino
United States,CA,Irvine
United States,CA,Monrovia

Then a macro does the following:
1. It seeks out the matching locations in Column A (regardless of the slightly different phrasing of the location).
2. It copies the corresponding codes into Column D.

So in summary, the macro helps me to seek out the codes of the locations I have pasted in Column C.

There is one last final step. But if I can get this far, I might be able to figure out the last step on my own.

Thank you anyone and everyone who has any tips!

~ML