SOLVED
Home

Copying data between worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-555982%22%20slang%3D%22en-US%22%3ECopying%20data%20between%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555982%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20two%20separate%20worksheets%20that%20have%20different%20sets%20of%20data.%20The%20first%20column%20on%20each%20sheet%20is%20an%20ID%20number%20column%2C%20which%20is%20the%20only%20commonality%20between%20the%20two.%20Worksheet%20A%20contains%20all%20possible%20ID%20numbers%20and%20Worksheet%20B%20contains%20a%20subset%20of%20Worksheet%20A.%20I%20need%20to%20copy%20all%20rows%20with%20data%20in%20Worksheet%20B%20into%20Worksheet%20A%20and%20match%20those%20rows%20based%20on%20ID%20number.%20How%20would%20I%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20example%2C%20I%20need%20to%20copy%20the%20number%20in%20the%20Host%20column%20in%20Worksheet%20B%20over%20to%20corresponding%20Donor%20ID%20row%20in%20Worksheet%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20guidance!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-555982%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-556144%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20data%20between%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339579%22%20target%3D%22_blank%22%3E%40michelle_sc98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20Michelle!%20You%20can%20apply%20a%20VLOOKUP%20formula%20in%20sheet%20A%2C%20referring%20to%20the%20range%20in%20sheet%20B%20that%20has%20all%20the%20information.%3C%2FP%3E%3CP%3EPlease%20check%20these%20videos%20and%20see%20if%20they%20help.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DE7gQ-PgYkMc%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DE7gQ-PgYkMc%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DhwL6KKJP-_I%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DhwL6KKJP-_I%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-hJxIMBbmZY%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-hJxIMBbmZY%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps!%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck.%20%3B-)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-556321%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20data%20between%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556321%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339579%22%20target%3D%22_blank%22%3E%40michelle_sc98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20this%20formula%20in%20cell%20B2%20of%20Worksheet%20A%2C%20then%20copy%20the%20formula%20down.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(A2%2C'Worksheet%20B'!A%3AB%2C2%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20words%3A%20find%20the%20value%20from%20A2%20in%20the%20list%20in%20columns%20A%3AB%20of%20worksheet%20B%2C%20when%20found%2C%20return%20the%20value%20from%20the%202nd%20column%20(column%20B).%20If%20no%20match%20is%20found%20Vlookup%20will%20return%20an%20error.%20If%20an%20error%20is%20encountered%2C%20the%20formula%20returns%20a%20blank%20cell.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20618px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112861i7CDDA8ED2F95B67C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-05-10_13-54-30.png%22%20title%3D%222019-05-10_13-54-30.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-559919%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20data%20between%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-559919%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3BThis%20worked%20perfectly.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
michelle_sc98
New Contributor

I've got two separate worksheets that have different sets of data. The first column on each sheet is an ID number column, which is the only commonality between the two. Worksheet A contains all possible ID numbers and Worksheet B contains a subset of Worksheet A. I need to copy all rows with data in Worksheet B into Worksheet A and match those rows based on ID number. How would I do this?

 

In my example, I need to copy the number in the Host column in Worksheet B over to corresponding Donor ID row in Worksheet A.

 

Thanks for any guidance!!

 

3 Replies

@michelle_sc98 

Hi, Michelle! You can apply a VLOOKUP formula in sheet A, referring to the range in sheet B that has all the information.

Please check these videos and see if they help.

https://www.youtube.com/watch?v=E7gQ-PgYkMc

https://www.youtube.com/watch?v=hwL6KKJP-_I

https://www.youtube.com/watch?v=-hJxIMBbmZY

 

I hope this helps! 

Good luck. ;-)

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Find out how to do a VLOOKUP in Excel and for what situations you can use Excel's Vlookup and Hlookup formulas for. Download the free Excel Vlookup workbook here: http://www.xelplus.com/basics-vlookup-hlookup/
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials Quickly learn the ins and outs of Excel's VLOOKUP formula. I show 2 practical examples of the VLOOKUP formula. I also explain why your VLOOKUP formula might not be working correctly. Summary: The Excel VLOOKUP
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-Start.xlsx Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-FINISHED.xlsx Learn all you need to
Solution

@michelle_sc98 

 

Try this formula in cell B2 of Worksheet A, then copy the formula down. 

 

=IFERROR(VLOOKUP(A2,'Worksheet B'!A:B,2,FALSE),"")

 

In words: find the value from A2 in the list in columns A:B of worksheet B, when found, return the value from the 2nd column (column B). If no match is found Vlookup will return an error. If an error is encountered, the formula returns a blank cell.

 

2019-05-10_13-54-30.png

 

@Ingeborg Hawighorst This worked perfectly. Thank you!

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies