How to remove duplicate vlookup values

xor · #3 03-21-2017, 10:52 AM

With all due respect to the Moderator I think there is a bit more in it than what is explained in the fiveminuteslessons link.

If I understand it correctly, OP wants to use a normal VLOOKUP-formula if there is no duplicates for a given number in column A and another formula if there is duplicates.

If you can accept helper cells as shown in column F, I think you can use the array formula in column G.

I have not done any serious testing, so come back if you get problems.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Duplicate Values without a specific Unique Value	Brittni	Excel	1	02-01-2017 06:22 PM
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY	Lady18	Excel	1	09-10-2016 12:15 AM
Compare & remove both sets of duplicate values	mummy	Excel	1	03-28-2016 02:59 AM
VLookup multiple values and Sum	tinfanide	Excel	2	09-02-2014 11:41 AM
Rule to remove duplicate emails?	ReviTULize	Outlook	0	05-14-2013 01:15 PM