+ Reply to Thread
Results 1 to 5 of 5

Drop down duplicate lookup result

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,899

    Drop down duplicate lookup result

    Hi,

    i created drop down with % and lookup on it.
    the issue is that i have duplicate there:

    Screenshot_133.png

    How to based on list show appropriate result?

    So first 8,5 % --> show Res1
    Second 8,5 % --> show Res2

    Best,
    Jacek
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,764

    Re: Drop down duplicate lookup result

    One way would be to change the second 8.5 to 8.50000000001

    it'll make no practical difference, but will enable VLOOKUP to return the correct answer.
    Glenn



  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,899

    Re: Drop down duplicate lookup result

    thank you Glenn.

    It is to consider but lets wait if there is smarter solution.

    Best,
    Jacek

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,328

    Re: Drop down duplicate lookup result

    If the drop-down is prepared this way as it is at the moment (with Data Validation) I don't think it is possible.
    Data validation just changes the value of E7 leaving no evidence which value from the list it is.

    You could use dropdown created as combo box (from developer-insert-form controls). Then it displays values from the list, but in connected cell (I used cell under the combobox) it returns position f selected value on the input list. And of course you can use INDEX function in this case to find related value from second column.
    See attached example
    Attached Files Attached Files
    Best Regards,

    Kaper

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,899

    Re: Drop down duplicate lookup result

    Thank you Kaper!

    Best,
    Jacek

+ 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] Lookup result with 2 variables and copy the result formatting
    By hazeljohn19 in forum Excel General
    Replies: 9
    Last Post: 12-15-2020, 12:16 PM
  2. Replies: 0
    Last Post: 09-12-2016, 07:55 PM
  3. [SOLVED] duplicate result
    By saizajkn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2016, 09:21 AM
  4. Error with 2 lookup vector with 2 lookup result
    By Mdolasiya in forum Excel General
    Replies: 3
    Last Post: 11-06-2014, 06:18 AM
  5. HELP! vBa code for duplicate result
    By wedzmer in forum Excel General
    Replies: 2
    Last Post: 07-09-2014, 01:43 AM
  6. Lookup with drop down result
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2013, 06:35 PM
  7. [SOLVED] Vlookup in Duplicate Result Value
    By abhinavbinkar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 07:51 AM

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