+ Reply to Thread
Results 1 to 2 of 2

Return Results from two search columns

  1. #1
    Registered User
    Join Date
    03-01-2018
    Location
    Ashburn, VA
    MS-Off Ver
    2010
    Posts
    1

    Return Results from two search columns

    TIA!!

    I am trying to create a budget calendar and I have a worksheet with the list of bills to be paid. One column has a set day(Sun-Sat) and another column has a constant day(1,2,3,4....) for the same day of the month the bill is due. I am using index & small to look in the columns to get all values. My issue is that I need to return all results from both columns in my calendar. I am able to get results from one column or the other but not both. I'm having trouble writing the formula for the offset once it's finds the last result in the first column to start back at row 1 in the second column.

    Formula for Weekday column:
    =IFERROR(INDEX('Bill Payment and Holidays'!$F$8:$F$17, SMALL(IF(Monthly!K$2 ='Bill Payment and Holidays'!$C$8:$C$17, ROW('Bill Payment and Holidays'!$F$8:$F$17 )- 7,""), ROW() - 3 )),"")

    Formula for the MonthDay Column:
    =IFERROR(INDEX('Bill Payment and Holidays'!$F$8:$F$17, SMALL(IF(DAY(Monthly!N$3) ='Bill Payment and Holidays'!$D$8:$D$17, ROW('Bill Payment and Holidays'!$F$8:$F$17 )- 7,""), ROW() - 3 )),"")

    These are arrays confirmed with Ctrl+Shift+Enter

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,855

    Re: Return Results from two search columns

    Hello RHudson714 and Welcome to Excel Forum.
    It might help us to help you, if you would upload a sample workbook showing us the way the data is set up on the Bill Payment and Holidays sheet as well as what your expected results on the Monthly sheet.
    To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 4
    Last Post: 02-01-2018, 08:31 AM
  2. How to return multiple results in a search
    By jrlafrance in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-22-2017, 09:25 PM
  3. [SOLVED] Code to search Excel and return results even if part of search text is present
    By Taoyuan00 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2016, 09:20 AM
  4. Replies: 6
    Last Post: 08-22-2014, 08:47 AM
  5. [SOLVED] Userform Search to return results in columns in listbox
    By goffa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 09:53 PM
  6. How to search and return results
    By the deeb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-09-2011, 05:57 PM
  7. Return search results??
    By itsacatfish in forum Excel General
    Replies: 3
    Last Post: 09-02-2010, 01:33 PM

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