Need help comparing data in two columns

  • Thread starter Thread starter drew
  • Start date Start date
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!
 
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.
 
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

Excel Comparing two columns 1
Comparing two lists using two columns from each spreadsheet 1
Need help comparing 2 columns of number to find unique numbers 3
Comparing two spreadsheets 2
Excel Compare numbers on 1 tab to other tabs in workbook. 1
comparing columns in two spreadsheets 1
Average of Vlookup data 3
Sheet won't reference a named cell 4

Back
Top