#1
|
|||
|
|||
How to remove duplicate vlookup values
Hi All,
Please see attached. Here I've used VLOOKUP now. Actually I want value 'C' at clouded B/2 location. Instead of this VLOOKUP any other option available? Can you please help me? Thanks in advance. Excel file also attached here for reference. Regards, Sunil Thomas Last edited by suniltko; 03-20-2017 at 10:51 PM. Reason: Uploaded excel file as well. |
#2
|
||||
|
||||
Hi and welcome
here is one of the many sites that describes this technique https://fiveminutelessons.com/learn-...le-values-list
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
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. |
Tags |
cell value, duplicate line, vlookup |
|
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 |