You downloaded a contact list containing names and email addresses from your company system. A simplified example of the list is shown below.

In the list, you discovered that some names are missing from column B. In your folder, you have a backup copy which allows you to find all the missing names. Using VLOOKUP, you can quickly place those names in a separate column. However, that is far from perfect. You would like to merge the names in column D into Column B. Most people would have done it manually. If it is just a few names, you can manually do a few copy and paste and the job would have completed in less than a minute. But if there are hundreds of them,

then this solution is a time saver. Watch how it is done in this video.

[jwplayer mediaid=”1535″]


Leave a Reply