How can we use vlookup when there are duplicate rows ?

Question added by srikanth eppakayala , Senior Analyst , DELOITTE SUPPORT SERVICES INDIA PVT LTD
Date Posted: 2016/02/24

Upvote (0) Views (4) Followers (3) Answers (3) Report Question

by Rashid Rasool , Operations Officer Consumer Banking Division , Summit Bank Limited

We can use VLOOKUP if there is duplicate entries in raw by simply adding array formula AND, IF and INDEX with it..

by Fabian Dcouto , Finance Specialist , DYNCORP INTERNATIONAL

VLOOKUP can be used by adding a Logical test (If) within two criteria.

by IBRAHIM ISHKUKANI , Finance Manager , Asdam Trading

Solve Duplicate VLOOKUP function problem with COUNTIF formula that creates a column of unique values for the first column in the lookup table.

How do I eliminate the duplicate rows ?
Top Answer: You can use following ways to eliminate duplicates 1) DISTINCT < ... See More

Answers (2)
What is the easiest way to remove duplicate rows in a table ?
Top Answer: use distinct keyword in your query to remove duplication of data. its actually remove duplicated entry in ... See More

Answers (3)
What are the limitations and dangers of using VLOOKUP in Excel?
Top Answer: Vlookup is a great function but have too many limitations as seen from all your comments. Its great to kn ... See More

Answers (14)
how can i use vlookup formula in reverse order i.e. right to left in ms excel?
Top Answer: Please use INDEX+MATCH See More

Answers (2)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.