Register now or log in to join your professional community.
We can use VLOOKUP if there is duplicate entries in raw by simply adding array formula AND, IF and INDEX with it..
VLOOKUP can be used by adding a Logical test (If) within two criteria.
Solve Duplicate VLOOKUP function problem with COUNTIF formula that creates a column of unique values for the first column in the lookup table.