+ Reply to Thread
Results 1 to 3 of 3

Searching for values in a small list without using nested IFs

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    Caracas, Venezuela
    MS-Off Ver
    2016
    Posts
    1

    Searching for values in a small list without using nested IFs

    Hello everyone!

    I created this scheduler that shows appointments when you provide the days and a starting date. Problem is when I input a date that doesn't match the days selected I want the sheet to look for the next available day and start from there. For example: I select Fridays and Saturdays as the days but I introduce a date that happens to be a Monday, what I'm looking for is for it to look for the next Friday and start counting from there.

    I found a very long solution with several nested IFs, since I want to improve my skills I was wondering if there is a cleaner way to do it.
    What do you suggest? I'm attaching a sample so you can see for yourselves what I'm talking about.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-24-2020
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    95

    Re: Searching for values in a small list without using nested IFs

    Data and formulae scatter all over the spreadsheet; hard to understand what u need, say where is the input condition and where is the output

    But by intuition, Match or Frequency function could possibly come into play.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Searching for values in a small list without using nested IFs

    Look like there are few days OFF in a week? Maybe WORKDAY.INTL helps.

    With F1 is starting date
    Thu and Fri is closed.
    With open (0), close (1), starting from Monday.
    Please Login or Register  to view this content.
    to establish next workday.
    Quang PT

+ 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. Searching the values with combo box and list box.
    By Prabakaran3003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2017, 12:38 PM
  2. [SOLVED] Dependent Dropdown List Using Index and Small Won't Return Multiple Values
    By ebevis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2013, 02:28 AM
  3. searching for values in one list and transposing into another list
    By vivavo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2012, 03:41 PM
  4. picking same SMALL and LARGE values from list
    By Karolis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2011, 11:20 AM
  5. Replies: 4
    Last Post: 09-23-2009, 08:49 AM
  6. Replies: 7
    Last Post: 12-31-2005, 08:20 AM
  7. What function to select the last 3 small values from a list ?
    By Eric in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2005, 07:20 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