Say your List is in A2 to C100 on *both* sheets.

Enter this in D2 of SheetA:

=IF(ISNA(MATCH(A2,SheetB!$A$2:$A$100,0)),0,INDEX(S heetB!$C$2:$C$100,MATCH(A2
,SheetB!$A$2:$A$100,0)))

And copy down.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"worduser" wrote in message
...
I have a somewhat similar question as the previous user. I have two lists
of
companies that is sorted by an ID and Company name and volumes of a
product;
however, one list has 2000 companies and the other list has 300, I want to
combine the two worksheets into one master worksheet that combines all the
data but, for the same company it only shows once. This is what I have
right
now

Workskeet A Worksheet B
Name ID Product 1 Name ID Product 2
ABC 1 25 ABC 1 12
BBC 2 23 BBC 2 14
DDD 3 21

This is what I want

Worksheet A
Name ID Product 1 Product 2
ABC 1 25 12
BBC 2 23 14
DDD 3 21 0

Can someone help me with this?