+ Reply to Thread
Results 1 to 4 of 4

Vlookup Function with duplicate Values

  1. #1
    Registered User
    Join Date
    11-18-2019
    Location
    Delhi
    MS-Off Ver
    Office 2013
    Posts
    2

    Exclamation Vlookup Function with duplicate Values

    I have an excel sheet on which I have put Ranks for candidates according to their score.

    Now I want Names as per their ranks in Column F thru any Formula (not thru sorting option)

    If I use vlookup, it creates problem as there are duplicate ranks for many members.


    Pls support and suggest formula to put the require data.


    Rgrds
    Harshit Jain
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,402

    Re: Vlookup Function with duplicate Values

    In F6, copied down;

    =INDEX(A:A,AGGREGATE(15,6,ROW($A$6:$A$21)/($C$6:$C$21=E6),COUNTIF($E$6:E6,E6)))
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    11-18-2019
    Location
    Delhi
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Vlookup Function with duplicate Values

    Thanks a Lott Glenn..

    Its exact what I want.

    Thanks a Lot.


    Regards
    Harshit Jain

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,402

    Re: Vlookup Function with duplicate Values

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vlookup Duplicate values
    By thussain1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-21-2019, 10:04 PM
  2. Vlookup with Duplicate values
    By Noman050 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-19-2018, 01:26 PM
  3. [SOLVED] VLOOKUP where Duplicate Values
    By rz6657 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-18-2016, 12:09 PM
  4. [SOLVED] Vlookup duplicate values
    By JumpyJim in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2016, 03:23 PM
  5. [SOLVED] VLOOKUP and Duplicate Values
    By marshak in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2015, 01:43 AM
  6. Need help with vlookup in duplicate values
    By vivshan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2013, 05:54 AM
  7. VLookup Duplicate Values
    By markd87 in forum Excel General
    Replies: 0
    Last Post: 07-20-2011, 11:54 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1