+ Reply to Thread
Results 1 to 7 of 7

Multiple results list from VLOOKUP

  1. #1
    Registered User
    Join Date
    06-20-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Multiple results list from VLOOKUP

    Hello,

    I am struggling with creating a new list from a table...

    Clipboard01.jpg

    I can't figure out how to have the formula (C1) fill down to show a vertical list of Room Names which have not paid a Key Deposit. I just want a list of Room Names to be produced from any "Not Paid" in column A.

    Can anyone help please?

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    638

    Re: Multiple results list from VLOOKUP

    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,518

    Re: Multiple results list from VLOOKUP

    Welcome to the forum.

    Add a name in cell A1

    Filter on column A and select not paid.

    data => filter.

    Then you have your list.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Registered User
    Join Date
    06-20-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Re: Multiple results list from VLOOKUP

    Thank you so much oeldere!

    It worked for me...

    But is there a way that you know of that can automatically create a list with formulas, that can be updated without clicking any filters etc...

    Thanks!

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,316

    Re: Multiple results list from VLOOKUP

    Try this in C1:

    =IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($A$2:$A$20)/($A$2:$A$20=$L$1),ROWS($C$1:C1))),"")

  6. #6
    Registered User
    Join Date
    06-20-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Re: Multiple results list from VLOOKUP

    Amazing, this worked a treat!!!! Thanks so much Phuocam...

    One more question, If I wanted to include another value in the lookup - both Not Paid and Paid - and I put "Paid" in L2, is there a way to have the automated list that includes both values?

  7. #7
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,316

    Re: Multiple results list from VLOOKUP

    Yes, you can try this:

    =IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($A$2:$A$20)/(($A$2:$A$20=$L$1)+($A$2:$A$20=$L$2)),ROWS($C$1:C1))),"")

+ 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. Vlookup to update the duplicate results in list(data validation list)
    By cheTAN kc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2017, 10:06 PM
  2. VLOOKUP multiple results in a drop down list
    By ronakvora38 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2017, 12:46 PM
  3. [SOLVED] using Vlookup with multiple results and averaging the results.
    By xatomicx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2015, 10:19 AM
  4. Using vLookup based on results from a vLookup & returning an undetermined list
    By NormalityBan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-14-2014, 05:02 AM
  5. Replies: 3
    Last Post: 10-30-2013, 09:18 AM
  6. [SOLVED] VLOOKUP multiple results in a drop down list
    By tnfire in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 07-14-2012, 12:31 PM
  7. Vlookup, multiple results and drop down list?
    By korvo in forum Excel General
    Replies: 3
    Last Post: 09-06-2010, 11:01 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