Display name that is on the list

[lintan]

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.

 

[CLR]

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)),"",VLOOKUP(A1,Sheet2!A:A,1,FALSE))

Vaya con Dios,
Chuck, CABGx3