software

pls advise which functions should be used if I want to combine below two sheet

Sheet One 2004
Product qty
milk 2
apple 3
pearl 4

sheet two 2005
Product qty
Sugar 2
apple 3
pearl 4

I hope get result like thisProduct 04 qty 05 qty
milk 2 0
apple 3 3
pearl 4 4
Sugar 0 2

thanks.
where are the results to be displayed ? if you want the results on page 3
enter data in products col , and use the vlookup function to compare cellquot;Donnaquot; wrote:

gt; pls advise which functions should be used if I want to combine below two sheet
gt;
gt; Sheet One 2004
gt; Product qty
gt; milk 2
gt; apple 3
gt; pearl 4
gt;
gt; sheet two 2005
gt; Product qty
gt; Sugar 2
gt; apple 3
gt; pearl 4
gt;
gt; I hope get result like this
gt;
gt;
gt; Product
gt; milk 2 0
gt; apple 3 3
gt; pearl 4 4
gt; Sugar 0 2
gt;
gt; thanks.
gt;
gt;

this assumes your data for product is in col a, and the quantity is in Col B

sheet 3

Product 2004 2005
Milk =VLOOKUP(A3,Sheet1!A:B,2,FALSE) =VLOOKUP(A3,Sheet2!A:B,2,FALSE)

quot;Donnaquot; wrote:

gt; pls advise which functions should be used if I want to combine below two sheet
gt;
gt; Sheet One 2004
gt; Product qty
gt; milk 2
gt; apple 3
gt; pearl 4
gt;
gt; sheet two 2005
gt; Product qty
gt; Sugar 2
gt; apple 3
gt; pearl 4
gt;
gt; I hope get result like this
gt;
gt;
gt; Product 04 qty 05 qty
gt; milk 2 0
gt; apple 3 3
gt; pearl 4 4
gt; Sugar 0 2
gt;
gt; thanks.
gt;
gt;