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)

CCI Pro

Published by

CA ROSHAN TIWARI
(salaried)
Category Students   Report

2 Likes   36951 Views

Comments


Related Articles


Loading


Popular Articles




CCI Pro
Follow us

CCI Articles

submit article