Home / Computer Science / Miscellenious / How to compare data in Excell by using Vlookup and Match Functions
Match function
Match Function Example

How to compare data in Excell by using Vlookup and Match Functions

In this article I am going to explain how to compare two excel sheets data and highlight the missing data. This article is helpful in BPO industry those who are dealt with finance and insurance sector.

Now a day’s everything automated in this comparison of two excel sheets is taking too lengthy process and our eyes also gets strained so to avoid that read the article and practice yourself with a sample data. If you have any questions let me know.

Here I am using two functions.

MATCH()
Vlookup()

Usage of Vlookup() function in Excel:

Here is the syntax for Vlookup() function.

vlookup
Vlookup

First go to formulas tab and select Lookup & Reference then click on VLOOKUP():

VLookup
Lookup function in Excel

Based on the syntax of the function pass the values like below:

Lookup Value – > What is the required value for searching.

Table Array -> Select the range where you want to find the given element.

Column Index -> Column number

Range Lookup -> True or False

VLookup
Lookup function in Excel

See the below practice excel sheet which contains the data:

vlookup
vlookup

By Using MATCH() Function:

Match Function Syntax:

match
Match() function Syntax

Go to formulas tab and select Lookup & Reference then click on MATCH().

Fill the formula columns like below:

Look up value -> What the element you want to search, select that column.

Look up array -> Where you want to search the element select the range.

Match Type -> It is 0,1,-1 0 for exact match 1 or -1 greater than or less than

Match Function
Match function

See the below practice excel sheet which contains the data:

Match function
Match Function Example


PLEASE NOTE : in the above practice sheet NA means no match found.

About Santosh Kumar Gadagamma

I'm Santosh Gadagamma, an Experienced Software Engineer passionate about sharing knowledge in technologies like Java, C/C++, DBMS/RDBMS, Bootstrap, Big Data, Javascript, Android, Spring, Hibernate, Struts, and all levels of software design, development, deployment, and maintenance. I believe computers are essential for the world's functioning, and I'm committed to helping others learn the skills they need to succeed in tech. My website is a valuable learning tool to help you reach greater heights in your education and career, and I believe that education has no end points.

Check Also

free crypto tokens

8 Websites for Unlocking Free Crypto: A Comprehensive Guide to Airdrop Crypto Tokens | IT2EDU

Explore the world of free crypto tokens and airdrop opportunities with our comprehensive guide. Learn how to navigate airdrops, claim free crypto, and safeguard against potential risks while diving into the evolving landscape of cryptocurrency giveaways