Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

How to program excel to compare two columns and give an answer of yes or no if duplicates are found?

I have an old list of inventory with the unique key of part numbers. Then I have another spreadsheet which identifies what prart numbers are no longer in production. I dont want to erase them i just need to compare and have outlook populate another column which will read out "yes" or "no". Basically compare two columns and if it finds duplicates to populate another column with the word yes.
0
Osram34
Asked:
Osram34
  • 2
1 Solution
 
BusyMamaCommented:
=IF(VLOOKUP(your cell with the part number here,your worksheet and range here,your column with the matching value here,FALSE)<>"","No","Yes")

Mine looks like this
=IF(VLOOKUP(C63,Sheet1!F1:G2,1,FALSE)<>"","Yes","No")

You must have the worksheet with the part numbers no longer in production sorted by part number.
0
 
Osram34Author Commented:
Let me give it a shot and ill get back to you might need little more info but thanks seems like you know your stuff busymama... ohh and i love the screen name :)
0
 
Osram34Author Commented:
BusyMoma just made me un busy!! thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now