Identify duplicate names in data base using vlookup in excel



SAMPLE DATA IS GIVEN BELOW:

WRITE THE NAME YOU WANT TO CHECK FOR DUPLICATE ENTRY IN CELL C4 AS SHOWN BELOW:

WRITE THE FORMULA IN CELL D7 & COPY IT FOR CELL ADDRESS AS SHOWN BELOW:

WRITE THE FORMULA OF VLOOKUP IN CELL D4  AS SHOWN BELOW:

IF THE NAME IS THERE IN THE LIST YOU WILL GET THE CELL ADDRESS AS RESULT AS SHOWN BELOW:

For more details on vlookup check my video on /video/excel-basics-vlookup-2450.asp

For excel file on this example with macros check share file section: IDENTIFY DUPLICATE ENTRY.

Note: Hypothetical data has been used in the example.


37078 Views 2 Likes Comment   Share Students   Report


About the Author

salaried

CA with 13+ years of post qualification experience.. an expert in MIS, Excel..a good analyst and programmer in Excel.

Comments :

Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details