+ Reply to Thread
Results 1 to 4 of 4

Return multiple values (Concatenate) values from ranges

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    Omaha, NE
    MS-Off Ver
    Office 2013
    Posts
    2

    Unhappy Return multiple values (Concatenate) values from ranges

    A bit of a stretch, I believe... But I've made a "Budget Calendar" so to speak.., with my bills on the first sheet, and the Months in the following sheets. What I'm trying to do is say, for instance, the day is the 11th on the calendar, (there are two bills due on this day), and I have the bill scheduled to be on the 11th, can I use a formula to return what bills are due?

    On the "Bill Dates" sheet, you can see where I'm kind of going with this...

    On the August calendar, under the 11th, I want it to say "Internet, gas (utility)" in cell D20, or "Internet" and "gas (utility)" in D20&21, respectively.

    I can get E20 to return the total bills due for the day using "=VLOOKUP("11th",'Bill Dates'!$B$2:$D$395,3,FALSE)", and it'd be awesome if I could get it to return them in different rows as well.

    I'm trying to keep it macro free, but, some things are impossible... :/ haha Thanks in advanceFinance Calendar.xlsx

  2. #2
    Registered User
    Join Date
    07-30-2014
    Location
    Omaha, NE
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Return multiple values (Concatenate) values from ranges

    Hmm... not possible? haha

  3. #3
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Return multiple values (Concatenate) values from ranges

    An unsophisticated solution is to make it so you don't have duplicate dates and rearrange the columns. This allows you to pull one unique bill per day.
    Attached Files Attached Files

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Return multiple values (Concatenate) values from ranges

    Here you go, there are array formulas, unique in each cell, unique in each group. It will pull in p to 4 bills per day, 3 on the days you're recording a paycheck in the same area.

    This does not utilize the Bill Dates sheet, it is getting the values right out of the first table in the Bills sheet.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Replies: 3
    Last Post: 07-24-2014, 01:58 AM
  2. Replies: 6
    Last Post: 06-11-2014, 12:54 AM
  3. [SOLVED] Return value if within range, return multiple values if ranges overlap
    By cde1983 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2013, 06:16 AM
  4. Lookup/ Return and concatenate values based upon multiple criteria
    By steveboise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2013, 10:43 AM
  5. Find if values are between ranges and return code and values
    By ozzbaldo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2007, 09:52 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