![]() |
#1
|
|||
|
|||
![]() 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
__________________
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 |
#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 |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count Duplicate Values without a specific Unique Value | Brittni | Excel | 1 | 02-01-2017 06:22 PM |
![]() |
Lady18 | Excel | 1 | 09-10-2016 12:15 AM |
![]() |
mummy | Excel | 1 | 03-28-2016 02:59 AM |
![]() |
tinfanide | Excel | 2 | 09-02-2014 11:41 AM |
Rule to remove duplicate emails? | ReviTULize | Outlook | 0 | 05-14-2013 01:15 PM |