How to remove duplicate vlookup values

		Microsoft Office Forums > Microsoft Excel > Excel
How to remove duplicate vlookup values

FAQ

Thread Tools

Display Modes

03-20-2017, 10:44 PM

suniltko

Windows 7 64bit How to remove duplicate vlookup values

Office 2010 64bit

Novice

Join Date: Mar 2017

Location: Cochin, Kerala, India

Posts: 12

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

Capture.JPG (43.1 KB, 22 views)

Attached Files

Test.xlsx (9.3 KB, 13 views)

Last edited by suniltko; 03-20-2017 at 10:51 PM. Reason: Uploaded excel file as well.

Tags

cell value, duplicate line, vlookup

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:47 PM.