0

So, I have a spreadsheet with about 5000 rows. Each of these rows has a unique number in column A, followed by some data in column B:

| A     | B          |
|-------|------------|
| 5142  | Test       |
| 5348  | Some stuff |
| 32665 | More stuff |
| 74568 | More stuff |

In another spreadsheet, I have some different data, for SOME of the IDs in my first spreadsheet, but not all of them:

| A     | B         |
|-------|-----------|
| 5348  | 1/1/2017  |
| 74568 | 6/25/2018 |

What I want to do is copy these columns from the second spreadsheet into the first spreadsheet, but I need the rows to spread out to paste into the corresponding rows from spreadsheet 1, so what I end up with is this:

| A     | B          | C     | D         |
|-------|------------|-------|-----------|
| 5142  | Test       |       |           |
| 5348  | Some stuff | 5348  | 1/1/2017  |
| 32665 | More stuff |       |           |
| 74568 | More stuff | 74568 | 6/25/2018 |

Any idea how I can accomplish this?

0

set cell C to:

=vlookup(A1,sheet2!A:B,1,FALSE)

and cell D to:

=vlookup(A1,sheet2!A:B,2,FALSE)

Where your data in sheet 2 is in columns A and B.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.