find result from two sheet
I have two sheet have similar numbers, I want combine them ASAP. The
struction like this :
First Sheet (2004) :
Product QTY
Apple 2
pearl 4
milk 5
second sheet (2005)
Product QTY
Apple 5
pearl 3
sugar 5
I hope can get result like this :
Product 2004 2005
Apple 2 5
pearl 4 3
milk 5 0
sugar 0 5
is there anyone can tell which function can be used to combine , I have
hundreds of lines, if do by manel, I am afraid I need at least one day.
|