Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I compare data between spreadsheets?
I have a workbook with 2 sheets. On sheet 1 have a list with about 13500 part
numbers. On sheet 2 I have about 12500 part numbers. On sheet 1 There is only data in column A on sheet 2 there is data in Column A, B (Item Name), and C (letter). What I want to do is compare all the part numbers from each column A and if they match pull the info from Column B and C on sheet 2 and fill it in column B and C with the correct information. I also would like to be able to see which part numbers are different between the 2 sheets. Thanks |
#2
|
|||
|
|||
Do you mean to fill Column B & C on sheet 1 if they are matching pair? Try the following: B3 = IF(MATCH($A3,Sheet2!$A$1:$A$12500,0),INDIRECT("She et2!B"&MATCH($A3,Sheet2!$A$1:$A$12500,0)),"") C3 = IF(MATCH($A3,Sheet2!$A$1:$A$12500,0),INDIRECT("She et2!C"&MATCH($A3,Sheet2!$A$1:$A$12500,0)),"") If you do not want to see "#N/A" for non-matching pair, put in another IF statement if ISERROR output "". I think there is a way to hide error output too, but I am not sure how. Hope it helps Bryan Wrote: I have a workbook with 2 sheets. On sheet 1 have a list with about 13500 part numbers. On sheet 2 I have about 12500 part numbers. On sheet 1 There is only data in column A on sheet 2 there is data in Column A, B (Item Name), and C (letter). What I want to do is compare all the part numbers from each column A and if they match pull the info from Column B and C on sheet 2 and fill it in column B and C with the correct information. I also would like to be able to see which part numbers are different between the 2 sheets. Thanks -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=387990 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to compare a pivot table refreshed data to old one | Excel Discussion (Misc queries) | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
How do you merge two spreadsheets to update data. | Excel Discussion (Misc queries) | |||
Excel should be able to compare 2 spreadsheets to find differing . | Excel Discussion (Misc queries) | |||
How can I compare to spreadsheets | Excel Worksheet Functions |