Merge Excel Documents

JamesonJendreas
JamesonJendreas used Ask the Experts™
on
So I've got two excel spreadsheets that have a column with a unique ID in it.  They also both have two other columns in common.  In one sheet, the two columns have data, the other I'm manually filling in from the first.

Is there a way to merge\import the data from one sheet to another by the unique ID they have in common
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi, JamesonJendreas.

Please see attached which does one column. The formula in New.xlsl is...
=IFERROR(VLOOKUP(B1,[Old.xlsx]Sheet1!$B$1:$C$6,2,0),"")

Regards,
Brian.New.xlsmOld.xlsx
Thanks, JamesonJendreas.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial