Display name that is on the list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display material with usage 4
Display material and activity 4
multiple vlookup's 5
Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Help With MS Access 4
Comparing lists of data 7
Update cell value based on name and specific date 1

Back
Top