Display name that is on the list
 

I have two sheets. The first sheet contains a list of materials that were
used for the calendar year. The second sheet contains a list of material that
were previously and currently used. I would only like to list that materials
from the second sheet that are also in the first sheet. An example:

Sheet 1 contains:
Paint
Thinner
Adhesive
Lubricant


Sheet 2 contains:
Paint
Thinner
Adhesive
Brush
Roller
Lubricant

Therefore, my new list should only contain Paint, Thinner, Adhesive, and
Lubricant.

Thank you for the help.

Assuming both lists start in A1 of each sheet............put this in B1 and
copy down.........

=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"",VLOOKU P(A1,Sheet2!A:A,1,FALSE))

Vaya con Dios,
Chuck, CABGx3



"lintan" wrote in message
...

I have two sheets. The first sheet contains a list of materials that were
used for the calendar year. The second sheet contains a list of material
that
were previously and currently used. I would only like to list that
materials
from the second sheet that are also in the first sheet. An example:

Sheet 1 contains:
Paint
Thinner
Adhesive
Lubricant


Sheet 2 contains:
Paint
Thinner
Adhesive
Brush
Roller
Lubricant

Therefore, my new list should only contain Paint, Thinner, Adhesive, and
Lubricant.

Thank you for the help.