Data lookup formulas

[sv29]

I was hoping someone could help me with a problem I am currently working on:

I have 2 different data sets which are dumped into 2 separate tabs in excel, 1 of the date set is all the costs i have on a project and will be updated monthly by simply adding the previous months costs to the bottom next available rows (not doing a complete data dump). The second tab will be a data dump breaking down the PAYROLL costs into each person, again this data will be updated monthly, however this can be a complete redump of all the months data if need be.

Please see attached example, my goal is to have the PAYROLL data in the Cost Dump tab to breakdown and show all the detail of these costs on the same tab and produce a result as per the Expected Tab. The Cost Dump tab will essentially be the master tab as i will be also added comments/notes against the other costs (ex Rental, Lease, consultant, etc.), so i don't want that information lost every time i do a dump. My vision would be that every month i would add the additional lines of costs to the Cost Dump tab and then as i update the Labour Dump tab, the Cost Dump tab would just add in the additional rows and populate the columns D-H automatically.

Could someone please help with a formula or macro to do this?

Thanks

[macropod]

Cross-posted at: http://www.msofficeforums.com/excel/...-formulas.html
and at: https://www.ozgrid.com/forum/forum/h...lookup-problem

Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq...._new_faq_item3

Kindly don't make a habit of this - I note you've been taken to task about this both here and on other forums before...

[sv29]

Sorry, I didn't realize all forums are connected and cross-posting inst allowed without posting the links to the other forums, my mistake, ill make sure it doesn't happen again.

I have this same topic posted on the following sites/forums:
Sorry, for some reason I can not post links in my reply's, however the sites are;
www.msofficeforums.com - excel - 38908-data-lookup-formulas
http://www.ozgrid.com-forum-forum-he...lookup-problem


That being said, i do no not have a solution to this problem yet, so any help would be greatly appreciated.

Thanks

[macropod]

I didn't realize all forums are connected

They're not - which is why cross-posting is an issue. If they were connected, you'd be getting pinged for duplicate posting...

[sv29]

Solution found