Identify duplicate names in data base using vlookup in excel

CA ROSHAN TIWARI , Last updated: 01 August 2020  
  Share

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

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 2999/-

Offer Price : INR 1999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)
🤖 Summarize this with AI: 💬 ChatGPT 🔍 Perplexity 🤖 Claude 🔮 Google AI Mode 🐦 Grok

CCI Pro

Published by

CA ROSHAN TIWARI
(salaried)
Category Students   Report

Other Articles  
Comment   Share
2 Likes   36951 Views
Comments

Related Articles


Loading


Popular Articles




CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Trending Online Classes

view all classess
Follow us

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category