Excel Report Help Needed

[A_Kubiak]

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.

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!<!-- google_ad_section_end -->

 

[silkfire]

Just copy the lines?

Select them in the second sheet, Ctrl+C and paste them where you need them in the first sheet.

 

[sinfulloyolite]

Hello,

Try using the below formula for your concept.

=VLOOKUP(A33,$A$33:$B$42,2,0)

Thanks,
Prem

 

[sinfulloyolite]

After executing the formula, you need to format the cells into Date format to get the exact output.

Thanks,
Prem

 

[A_Kubiak]

thanks for the replies, im going to try that formula now. I cannot copy the lines from sheet 2 into sheet one bc then the lines would be duplicated. 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.

I may not have made it clear in my first post, and if thats so i apologize.

Thanks

 

[sinfulloyolite]

All the best!!

 

[A_Kubiak]

thank you for the help, it did work. i really apreciate it.

 

[silkfire]

Are the rows in Sheet 2 consecutive? What I meant was you could replace the faulty dates with the correct ones if all the 7800 rows follow one by one.

 

[A_Kubiak]

i lied, its not working for me on my sheets. I think it is more human error than anything.

 

[A_Kubiak]

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:
<CITE>skydrive.live.com</CITE>

Username: A_Kubiak@comcast.net
Pass: aek15234

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

Thank you again