I've an excel file where Column A got addresses. Column D got list of Cities. I need a formula to look at the Column A against Column D and if the any one of the cities listed in Column D is present in Column A, it has to return the City name in Column B. How to do this? Any idea? Thanks in advance.
Yea, I usually use vlookup() function for that kind of task. But, to make it clear, can you give a sample (one or two row) of the data? So I can figure it out.