Excel 2007 : Finding Matching Values in Separate Sheets and Copying Corresponding Data

[hamidxa]

So, I'm working with 2 different reports.

Sheet 1, Column A has product models numbers
Sheet 2, Column A, has most of the exact same model numbers

Sheet 1, Column B has a QTY count
Sheet 2, Column B does not have a QTY count

I would like to:
Copy the QTY count from Sheet 1 Column B
to Sheet 2 Column B as long as it corresponds to the same model number

So for example:
If Sheet 1 Column A contains the model number "32LK" in cell A6
And Sheet 1 Column B contains the QTY 15 in cell B6

And Sheet 2 Column A contains the model number "32LK" in cell A14
Then I would like the QTY of 15 copied into Sheet 2 cell B14


This will need to check for all matching model numbers in both columns in both sheets and copy all applicable QTY values accordingly as stated above.


Really struggling to find a solution here, so help would be EXTREMELY appreciated!


Thanks in advance

[TMS]

You need to use VLOOKUP.

=VLOOKUP($A14,'Sheet1'!$A:$B,2,FALSE)


Regards, TMS

[arlu1201]

Hamidxa,

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.