Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can we use vlookup when there are duplicate rows ?

user-image
Question added by srikanth eppakayala , Senior Analyst , DELOITTE SUPPORT SERVICES INDIA PVT LTD
Date Posted: 2016/02/24
Rashid Rasool
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..

Fabian Dcouto
by Fabian Dcouto , Finance Specialist , DYNCORP INTERNATIONAL

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

IBRAHIM ISHKUKANI
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.

More Questions Like This