Combining two data sets (tables), with one common denominatior

**lomacm** · 05-28-2013, 01:54 PM

I have attached an image of my two Tables, I am trying to combine these sheets into a summary page or chart using the "Project" as what groups the data together, I have tried to use =Vlookup, but cannot seem to make that work!

Please help!

Untitled.png

**dilipandey** · 05-28-2013, 02:16 PM

Hi lomacm,

welcome to the forum.

Instead of an image, upload a Excel workbook so that forum members can give a quick practical shot. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**lomacm** · 05-28-2013, 03:25 PM

Book123.xlsx

Here is the spreadsheet!

**dilipandey** · 05-29-2013, 02:59 AM

Okay.. both sheet have common projects though repeated

but what about Expense and Vendor columns ?

Labour sheet has 4 rows for project "Bins" but Materials sheet has 11 rows .. now how many you want 15 or 11 (including 4 from labour sheet).. can you show your expectations basis this scenario ? Thanks.

Regards,
DILIPandey
<click on below * if this helps>