Checking for exsitence of values in a different worksheet

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

Guest

I have two work sheets defined, Sheet1 column A contains a list of part
numbers.
Sheet 2 column A contains a list of part numbers.

I would like to create a formula in Sheet1 column B that displays "True" if
the part number exists in Sheet 2 column a.

I tried Vlookup, but seem to be having issues.
 

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

Need help with a formula, please!!! 2
Cross-Referencng numbers between worksheets 3
vlookup with if statement together 6
Need formula to add cells with same group 1
auto fill or if function 2
Count if based on criteria within cells on another sheet 1
Matching column in different sheet 1
Excel VBA 1

Back
Top