Report Help on Matching Cells and Replacing Data

Hi there, I could really use some help with this report in Excel. Me and my boss have been trying to get this to work for 3 days now and its come to the point that we are not going to get it unless someone is nice enough to give some advice.

We have a report with 2 different sheets. On sheet one there are 13,000 rows of data and columns A-H are filled with different data. column A is our item id and column G has a date that states when the item was sold last. Well, the date in column G is wrong for about 7800 rows and needs changed.

The second sheet in the file is the 7800 rows with just the item id in column A and the correct date in column B. We are looking for an easy way to replace the rows in the first sheet with the correct information from the rows in the second sheet without manually replacing it line by line.

I almost forgot to add in, that in both sheets, column A with the item ids are the same item ids on both those sheets. So column A on sheet one has 13000 rows and included in those 13000 are the 7800 item ids on sheet 2.

We tried using the VLookup function that is incorporated into excel but had absolutly no luck, mostly because we have never used this function before.

Sheet one already has all the lines of sheet 2, its just that sheet one has the wrong dates for the item ids and sheet 2 has the correct dates. im trying to replace the dates on sheet one from the dates on sheet 2 matching on the item ids from both sheets.


Any suggestions/help/feedback on this matter would be greatly appericiated.

By the way, We are using Excel 2000. I know, its old but it still works
Thank You!

File is saved online if anyone would like to take a look at it, i know its asking alot of you guys/girls out there but this is hell for me and driving me insane. plus i think that i am not phrasing the issue correctly so to help me out i figured posting the file online to look at might save me.

File Location:
skydrive.live.com

Username: [email protected]
Pass: aek15234

File is in documents folder, it is the only file in my skydrive to make it easier to locate.

in a spare column on sheet 1 in the first cell put
=VLOOKUP(a1,sheet2!A:B,2,FALSE)
and drag down to end of list
this should look at id in columnA of sheet 1 compare it with column A Of sheet 2
if it finds a match it will give you back the date from column b of sheet 2
thats the basics but as you have dates that are correct and there is no replication on sheet 2
it might be better to insert a new column after g in sheet 1
then put =if(isna(VLOOKUP(a1,sheet2!A:B,2,FALSE)),G1,VLOOKUP(a1,sheet2!A:B,2,FALSE))
and drag down
this will fill the column with the new date from sheet 2 or the existing date from sheet1 if no match is found.