Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
All Courses
  • Free Training Courses
  • AI for Your Role
  • AI & Machine Learning
  • Cloud Tech
  • Data Science
  • DevOps
  • Dashboarding/BI
  • Database
  • WebDevelopment
  • Programming & Coding
  • MS Office & Workplace Productivity
  • QA & Test Automation
  • Professional & Career Development
  • Cyber Security

Courses

  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
  • Microsoft Azure for Beginners
  • AWS Cloud for Beginners
  • Oracle SQL Fundamentals
  • Tableau Fundamentals
  • Power BI Fundamentals
Explore All Programs

Courses

  • AI Essentials
  • AI for Administrative Professionals New Launch
  • AI for Managers & Team Leads
  • AI for Data Analytics & Power BI
  • AI for Software Developers
  • AI for Database & SQL Professionals
  • AI for Project Managers
  • AI for Marketing Professionals
  • AI for Sales Professionals
  • AI for HR Professionals
  • AI for Finance Professionals
  • AI for Customer Support Professionals
  • AI for QA & Test Engineers
  • AI for IT Support & System Admins
  • AI for Cybersecurity Analysts
  • AI for Job Seekers
Explore All Programs

Courses

  • Learn Claude Basics New Launch
  • Learn Claude Advanced New Launch
  • Applied Artificial Intelligence (AI) New Launch
  • AI for Workplace Productivity
  • Azure Fundamentals with AI
  • Advanced Microsoft Azure with AI
  • AI Implications for Business Strategy
  • Mastering ChatGPT & Generative AI Tools
  • Prompt Engineering
  • Agentic AI Solutions
  • AI Product Management
  • AI for Quality Control
Explore All Programs

Courses

  • AZ-900 Azure Fundamentals
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
Explore All Programs

Courses

  • DP-100 Data Science on Azure
Explore All Programs

Courses

  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Explore All Programs

Courses

  • Business Analytics: From Data to Insights New Launch
  • Power BI Advanced
  • Data Analytics with Excel
  • Tableau Beginner
  • Tableau Data Consumer
  • Alteryx & Tableau
  • Tableau Advanced
  • Tableau Certification prep
  • Power BI Beginner
  • Cognos Analytics
Explore All Programs

Courses

  • SQL Server for Beginners
  • SQL for Analysts
  • SQL Server Advanced
  • SQL Server T-SQL Programming
  • SSIS
  • Oracle SQL for Beginners
  • Oracle PL/SQL
  • Oracle SQL Advanced
  • Big Data with Hadoop: HDFS, MapReduce & Ecosystem Tools
  • MS Access
Explore All Programs

Courses

  • Angular Frontend Development
  • Spring 5 Framework
  • Full Stack Web Development
Explore All Programs

Courses

  • Learn Python
  • Python PCEP
  • Python PCAP
  • JavaScript & jQuery
  • Java Certification
  • Python for Data Science
  • Machine Learning with Python
Explore All Programs

Courses

  • Analyzing Data with Excel New Launch
  • Workplace Digital Skills
  • Excel Beginners to Advanced Trending Now
  • Excel for Finance
  • Excel for HR
  • Workplace Computer Skills
Explore All Programs

Courses

  • Selenium QA Automation (Java)
  • Selenium QA Automation (Python)
  • API Testing
  • QA Automation with Python (Advanced)
Explore All Programs

Courses

  • Scrum Master Certification
  • Lean Six Sigma Green Belt Certification
  • Business Analyst
Explore All Programs

Courses

  • Cyber Security Foundations for Beginners
  • Computer Networking for Cybersecurity
  • Windows & Linux Security Administration
  • Ethical Hacking & Penetration Testing
  • Artificial Intelligence (AI) in Cybersecurity
Explore All Programs
  • About Us
    • OCA Skill Sprint Method
    • Meet the Founder
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

 

  • info@ohiocomputeracademy.com
  • +1 866-648-7284
  • Home
  • About Us
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Find With Us
  • Home
  • Blogs
  • MS Excel
  • Compare Two Columns in Excel with MATCH and ISNUMBER

Compare Two Columns in Excel with MATCH and ISNUMBER

If you’ve ever needed to compare two columns in Excel — such as employee names or IDs — to check which ones appear in both, you’re not alone. This task is incredibly common in HR and admin work, whether you’re cross-checking payroll lists, training attendance, or active vs. terminated employee records.

Fortunately, Excel provides a simple yet powerful way to do this using the MATCH and ISNUMBER functions. In this post, we’ll walk you through how to compare two columns and identify which values from one list exist in the other — step-by-step.

New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.

.

Use Case

Let’s say you have:

Column A — a list of employees who submitted a form
Column B — a master list of all current employees

Your goal: Check if each name in Column A is present in Column B.

How to Compare Two Columns in Excel Step-by-Step

To explain this concept, I will use the following sample data. It contains two columns of employee names. Some names from List 1 also appear in List 2. Our objective is to identify which employee names from List 1 exist in List 2 and which do not.

Comparing_two_columns_sample_data.png

Steps:

  1. In Column C, add a column header. You can choose any name; in my example, I used ‘Presence in Column B’.

  2. In Cell C2 use the Match function by typing the following formula:

=MATCH(A2,B2:B6,0)

How the MATCH Function Works?

The MATCH function in Excel is used to find the position of a specific value in a row or column. It doesn’t return the value itself — it returns the position number where the match is found.

Syntax:

=MATCH(lookup_value, lookup_array, [match_type])

lookup_value – The value you want to search for

lookup_array – The range of cells to search in

match_type – Optional. Use:

  • 0 for an exact match (most common)

  • 1 for less than (for sorted data)

  • -1 for greater than (also for sorted data)

In our example, MATCH(A2, B2:B6, 0): Searches for the value in A2 within Column B. If found, returns its position (e.g., 2 in the case of Alice); if not found, returns #N/A. You can autofil rest of the cells to see where is display #N/A

  1. Include the ISNUMBER function into the Match function you wrote above by inputting it in the formula bar as shown below:

=ISNUMBER(MATCH(A2,B2:B6,0))

What ISNUMBER Does in the Formula?

The ISNUMBER function in Excel checks whether a given value is a number. It returns:

TRUE if the value is a number

FALSE if the value is not a number, including errors like #N/A, text, or blank cells

Syntax:

=ISNUMBER(value)

value – This is usually the result of another function (like MATCH)

In our example, =ISNUMBER(MATCH(A2,B2:B6,0)) will return True in cell C2 because it has a number 2 (for Alice). You can autofill rest of the cells to see where it returns True or False.

  1. Now include ISNumber and Match functions you used earlier into an IF function by typing the following in the formula bar:

=IF(ISNUMBER(MATCH(A2,B2:B6,0)),"Present","Not Present")

This will be the final formula which will produce the desired result and show which names in List 1 are present in List B and which are not present.

How the IF Function Displays the Result

The IF function in Excel allows you to show different results based on whether a condition is TRUE or FALSE.

Syntax:

=IF(logical_test, value_if_true, value_if_false) 

In our example, we use IF to turn the TRUE/FALSE result from ISNUMBER(MATCH(...)) into a user-friendly message i.e. Present or Not Present.

If the name in A2 is found in Column B → MATCH returns a number → ISNUMBER is TRUE → IF returns “Present”

If not found → ISNUMBER is FALSE → IF returns “Not Present”

Final output: Comparing Two Columns in Excel

Comparing_two_columns_Final_Output.png

Final Output: Column C displays which names from List 1 are present in List 2.

Function Summary Table

Now that we’ve seen the final result in Column C, let’s break down how each Excel function contributes to this formula. The table below summarizes the role of each function used.

Function

Purpose

Returns

As Used in Our Example

Match

Finds the position of a value in a list

A number (if found) or #N/A (if not found)

MATCH(A2, B2:B6, 0) → returns row number where A2 is found in Column B

ISNUMBER

Checks if a value is a number

True or False

ISNUMBER(MATCH(...)) → returns TRUE if a match exists

IF

Returns a custom result based on whether a condition is true or false

Custom message or result

IF(ISNUMBER(MATCH(…)), "Present", "Not Present")

Comparing two columns in Excel is a common but powerful task — especially in HR, payroll, or training-related work. By combining MATCH, ISNUMBER, and IF, you can quickly identify which values exist in both lists and highlight any missing entries with clear, readable output. This method is one of the easiest ways to compare two columns in Excel.

Ready to Learn More?

Master Excel for real-world HR tasks with our hands-on training!

✅ Learn functions like VLOOKUP, SUMIFS, PivotTables, and more
✅ Build professional reports and HR dashboards
✅ Perfect for HR professionals, recruiters, and team leads

👉 Join Our Excel for HR Course or Explore more Excel blogs

Interested in mastering Excel beyond the basics?

Explore the comprehensive guide Excel Basics to Advanced – Design Robust Spreadsheet Applications Powered with Formatting, Advanced Calculations, Charts, Pivot Tables, and Macros.

New to Excel? Want to see Excel in action? Watch the full Excel for Beginners Playlist here:

Like
Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.

0 Comments

Add Your Comment

Post a Comment

Required fields are marked *

✅ Thanks for adding your comment! It will appear after moderation.

0 Comments

Related Blogs
View All Blogs
Why MS Excel is important for an IT novice
Read More
MS Excel Practice Questions
Read More
Excel Conditional Formatting Practice Questions
Read More
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

Registered with the Ohio State Board of Career Colleges and Schools — School Registration No. 2395

About Us
  • Contact Us
  • Our Story
  • Training Gallery
  • Reviews
  • Books
  • Greater Columbus Training Center
Trainings/Services
  • Course Categories
  • Learning Paths
  • Frequently Asked Questions
  • AI Advantage
Contact Us
  • Phone:+1 866-648-7284
  • E-mail: info@ohiocomputeracademy.com
  • Address:

    Dublin, Ohio
    5900 Sawmill Road, Suite # 150, Dublin, OHIO 43017 USA

Thank you
Failed
Free Training Courses
  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
AI Courses
  • Claude Basics
  • Claude Advanced
  • AI for Workplace Productivity
  • Prompt Engineering
  • Agentic AI Solutions
  • AI for Quality Control
Cloud Tech
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Technical Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
DevOps
  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Dashboarding/BI
  • Tableau Beginner
  • Power BI Beginner
  • Data Analytics with Excel
Database
  • Oracle SQL for Beginners
  • SQL for Analysts
  • SQL Server for Beginners
MS Office & Workplace Productivity
  • Workplace Digital Skills
  • Excel for Finance
  • Excel for HR
  • Excel Beginners to Advanced
  • Workplace Computer Skills
Learning Hub
  • Begin Your IT Career
  • Generative AI & Workplace Productivity Foundations
  • Claude AI Learning Path
  • Data Visualization Foundations
  • Data Analytics Career Path
  • AI for Business & Data Applications
  • Programming Foundations & Development Path

© 2026 Ohio Computer Academy. All rights reserved.

  • Privacy
  • Terms & Conditions