Previous Topic Next Topic

Match two columns in different sheets

Closed
mahee - Apr 17, 2009 at 07:33 AM
 mikloise - Apr 21, 2009 at 01:51 AM
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. :)

1 response

Answer 1 / 1
mikloise
Apr 21, 2009 at 01:51 AM
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.
26

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Modern Warfare 2 online cant find matchs why
Roryyy -
dwebb -

162 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses