Share via

Importing Data from another excel sheet using a Matching Column

Anonymous
2017-03-31T23:57:55+00:00

Hello so I have two sheets. On sheet 1 Column A is my identifying column for the contents of each row. In column P of sheet 1 I need to import data from another sheet.

On my sheet 2 I have Column A and Column B. Column A is my identifying column and column B is the data I want to import onto Column B.

I want to be able to put a formula in that will import the Column B sheet 2 data onto Column P sheet 1 when Column A is a match on both sheets. Does this make sense? Not really sure how to explain this. How can I do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-03T13:47:40+00:00

    I prefer not to share the download link here. Can I send it to you another way?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-04-02T23:07:55+00:00

    Hi,

    Upload your workbook to OneDrive and share the download link here.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-04-02T13:47:13+00:00

    Hi Ashish:

    Thank you for your reply. It still won't work. It just says N/A for all of them. Would you be willing to talk me through this?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-04-01T00:14:27+00:00

    Hi,

    Enter this formula in cell P2 of sheet1 and copy down

    =VLOOKUP(A2,'sheet2'!$A$2:$B$100,2,0)

    Hope this helps.

    Was this answer helpful?

    0 comments