+ Reply to Thread
Results 1 to 3 of 3

Combining two find functions

  1. #1
    Registered User
    Join Date
    01-19-2019
    Location
    dillsburg, PA
    MS-Off Ver
    Office 365
    Posts
    18

    Combining two find functions

    Hello all,

    I am having some trouble combining two find functions. Attached is a sample excel file that I am working in.

    You will see that Column A is the recipes I am working with.
    Column B states what meal of the day these recipes will be eaten. (B=breakfast, L=lunch, D=dinner).
    Column C states which days of the week these recipes will be eaten. (1=Monday or Day 1, 2=Tuesday or Day 2, etc).

    In the top table, Row 2 shows the formula that I was working with by just sorting the recipes by the day number. For instance, all recipes that I inserted a "1" beside would appear in F2. All recipes that I inserted a "3" beside would appear in H2.

    In the bottom table, I show you essentially the same formula as the table above, yet by searching for the corresponding meal time (B,L, or D) and this populates the table with recipes that contain the corresponding meal time.

    What I am trying to do is combine both of these into one function. The green text that I manually input in the top table is what I would like it to look like. Here, it first sorts by the meal time (B,L,D), and then by the day number (1,2,3,4,5,6,7).

    Your help is greatly appreciated!!
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Combining two find functions

    As request
    Please try at F2 with CSE

    =TEXTJOIN(" & ",,IF(ISNUMBER(FIND(F$1,$C$2:$C$6))*($B$2:$B$6=$E2),$A$2:$A$6,""))
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-19-2019
    Location
    dillsburg, PA
    MS-Off Ver
    Office 365
    Posts
    18

    Re: Combining two find functions

    Wow, that's incredible lol!! It worked perfect.

    Thanks again!!

+ 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] IF AND OR functions combining
    By Alphabex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2016, 06:43 PM
  2. [SOLVED] Combining MID, RIGHT & FIND Functions
    By TommyK25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2014, 05:34 AM
  3. Combining multiple functions>lookup/sum functions
    By mush106 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2013, 07:47 AM
  4. Combining functions
    By rangerel in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-01-2010, 07:43 AM
  5. Combining two IF Functions
    By sprejr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2007, 01:34 PM
  6. Combining functions
    By Steve in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2006, 12:55 PM
  7. [SOLVED] Combining IF AND & FIND Functions
    By Steve in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2006, 10:10 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