Test workbook.xlsx


Hi all, I am new here and I apologize now if I confuse you. I know this should be simple to accomplish but I can't seem to figure it out??

I have to run two seperate reports out of our system to get all the data I need. Than I must manually go in and add in the missing data from one to the other, while comparing the two worksheets to ensure both show all the same projects.

I have attached an example and wondering if you could help me figure out how to get the Budget to Actuals worksheet to populate the "date created" in column B from the second worksheet named project date. In one worksheet the project code and description is together in one cell and in the other worksheet it is broken out into two cells. Is there a way to get excel to match up say A5 in Budget to Actuals with A2 in Project Date and then pull the Date per that row into the Budget to Actuals spreadsheet appropriate cell?

The actual spreadsheet has about 10,0000 projects, also it is a weekly report as billings and expenses incur weekly, so this is something I do on a weekly basis and would like to automate it.