Need help comparing data in two columns

D

drew

I have data on the first tab that includes a unique ID #. I have a list of
ID#'s on a fourth tab that I'm trying to compare to list on first tab to let
me know "Yes" this ID is included from fourth tab or "No" Can anyone help?
Thanks!
 
S

Shane Devenshire

Hi,

=IF(COUNTIF(Sheet4!A$1:A$100,A1),"Yes","No")

I entered this formula on the first sheet in cell B1. Copy it down as needed.
 

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

Grouping Names in Mail Merge 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Using Styles In An Outline 0
MS Project Center-Autolink column fields 0
Drop down list control value in vba 2
Need help to update a column when Drop Down List is changed 0
Microsoft 365 Activations, Users or Devices? 0
Comparing two columns 0

Top