View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna
 
Posts: n/a
Default 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.