CCI Online Learning
What do you want to learn today?
     

Freedom sale - Get upto 30% discount in all CA CS CMA and Certification courses. Call Coaching: 1800-3000-0505 Certification course : 011-411-70713

CIBIL

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Identify duplicate names in data base using vlookup in excel

CA ROSHAN TIWARI 
Updated on 01 August 2020

LinkedIn


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.


Tags :



Category Students
Other Articles by - CA ROSHAN TIWARI 




Comments



Popular Articles



CCI Articles

submit article

Stay updated with latest Articles!







GST Live Class    |    x