Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rufus Williams   on Sep 30 In MS Office Category.

  
Question Answered By: Bonita Garcia   on Sep 30

You mentioned you have unequal entries in both lists, now assuming all enteries
in the shorter list are available in the longer list then it should be quite
easy if you take the longer list as the key in the Vlookup suggested by Ray.
However If you have unique entries in both lists then you'll have to go through
the second list again with another vlookup (there may be a simpler way to do
this) to identify the unique entries and copy them to the merged sheet.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to merge data from 2 spreadsheets Or get search suggestion and latest updates.


Tagged: