I have two worksheets w/multiple columns that I need taken from the 2nd sheet and moved to the 1st alongside the corresponding columns. Here's an example to make it clearer
Sheet 1 has 3 columns
ID Animal #
01 dogs 27
02 cats 12
03 lizard 8
04 ferrets 6
Sheet 2 has the same three columns (note columns 1 and 2 are the same on both sheets, the 3rd column is the only one w/different values).
ID Animal #
01 dogs 8
02 cats 21
04 ferrets 5
I need to make Sheet 1 look like this (Sheet 2 isn't as large as Sheet 1 so it should leave blanks where it doesn't correspond with Sheet 1 as the lizards row below)
ID Animal # ID Animal #
01 dogs 27 01 dogs 8
02 cats 12 02 cats 21
03 lizard 8
04 ferrets 6 04 ferrets 5
In my file I have thousands of columns in sheet 1 and hundreds in Sheet 2 so I can't do it manually. I originally was playing w/VLOOKUP but had no luck. Is there a formula anyone knows that can assist me, thanks.
Bookmarks