Results 1 to 11 of 11

Combination If Function

Threaded View

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

    Re: Combination If Function

    It appears that in order to add any of the last four attachments, attachment 1 is necessary.
    The drop down for cell A3 would only display Attachment 1
    The drop down for cell A4 would include the last four attachments but only if attachment 1 is chosen in cell A3, otherwise nothing is displayed
    The drop down for cell A5 will display the two appropriate attachments if attachment 2 is selected in cell A4, the one appropriate attachment if attachment 3 is selected in cell A4 and will not display any options otherwise.
    This avoids the customer choosing attachments that will not go together.
    Note that cells C3:C4 are populated using: =SUBSTITUTE(A3," ","_") and the results are hidden by choosing white as the font color.
    Note that the dropdowns in cells A4:A5 are populated using =INDIRECT(C3) and =INDIRECT(C4) respectively.
    Note that lists are placed in columns N:Q
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. help with IF function in combination with Search/OR function
    By Zoe_83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2014, 08:47 AM
  2. Using IF function with mutilple criteria in combination with MID function
    By ryguy104gt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2013, 06:03 PM
  3. [SOLVED] IF function combination of COUNTIF function
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2012, 01:53 AM
  4. Replies: 2
    Last Post: 08-16-2011, 04:22 PM
  5. Combination Function
    By theshark43 in forum Excel General
    Replies: 9
    Last Post: 03-02-2010, 03:40 PM
  6. IF and OR function combination
    By Mofa in forum Excel General
    Replies: 4
    Last Post: 03-20-2009, 08:27 AM
  7. Combination Function?
    By teresa2136 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2008, 10:20 AM
  8. [SOLVED] Help with Combination function
    By Santhosh Mani in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-14-2005, 12:45 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