Report

Match two columns in different sheets [Closed]

Ask a question mahee - Last answered on Apr 21, 2009 at 01:51 AM by mikloise
Hello,

I have three work sheets with columns namley process code, process name, quantity produced per day. I need to create another sheet comprises of process code, process name and quantity produced monthly so that to sum up all the quantity produced for a particular process that appears in all 3 sheets. I have tried pivot table but my data also has blank spaces, hence vlookup is then also not returning correct values. Please please somebody help me on this issue! I'll be very very thankful. :)
Helpful
+26
plus moins
What if you try =Sheet1!Cell needed do that for the start of all three columns and then just drag the formulas down the column.
Was this answer helpful?  

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!