Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2017, 10:44 PM
suniltko suniltko is offline How to remove duplicate vlookup values Windows 7 64bit How to remove duplicate vlookup values Office 2010 64bit
Novice
How to remove duplicate vlookup values
 
Join Date: Mar 2017
Location: Cochin, Kerala, India
Posts: 12
suniltko is on a distinguished road
Default 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
Attached Images
File Type: jpg Capture.JPG (43.1 KB, 22 views)
Attached Files
File Type: xlsx Test.xlsx (9.3 KB, 13 views)

Last edited by suniltko; 03-20-2017 at 10:51 PM. Reason: Uploaded excel file as well.
Reply With Quote
  #2  
Old 03-21-2017, 01:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to remove duplicate vlookup values Windows 7 64bit How to remove duplicate vlookup values Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi and welcome
here is one of the many sites that describes this technique
https://fiveminutelessons.com/learn-...le-values-list
__________________
Using O365 v2503 - 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
Reply With Quote
  #3  
Old 03-21-2017, 10:52 AM
xor xor is offline How to remove duplicate vlookup values Windows 10 How to remove duplicate vlookup values Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Attached Files
File Type: xlsx Lookup_Test.xlsx (14.4 KB, 13 views)
Reply With Quote
Reply

Tags
cell value, duplicate line, vlookup

Thread Tools
Display Modes


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 remove duplicate vlookup values How to convert VLOOKUP values to text on another sheet AUTOMATICALLY Lady18 Excel 1 09-10-2016 12:15 AM
How to remove duplicate vlookup values Compare & remove both sets of duplicate values mummy Excel 1 03-28-2016 02:59 AM
How to remove duplicate vlookup values 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft