Results 1 to 20 of 20

Return Text or Data Validation List

Threaded View

  1. #12
    Registered User
    Join Date
    01-28-2015
    Location
    TX, USA
    MS-Off Ver
    2013
    Posts
    69

    Re: Return Text or Data Validation List

    So, it translates like this?

    =IFERROR(INDEX(Range_to_Reference,AGGREGATE(smallest,ignoring_errors,(ROW(range_of_rows)-1)/(Within_RANGE-Greater_or_Less_Than"",ROW(From_rows-1to1))),"")
    Just to make sure I'm following.

    Also:
    D18 Should be equivalent to something to the effect of
    =IF(OR($D$10="","OptSelect"),INDIRECT("OptSelect"),$D$10)
    Where the Cells
    D19,D20,D21 would be something like
    =IF($D$18="OptSelect","",INDIRECT($D$18))
    I am sorry this is such a pain.
    Last edited by Entregan; 10-13-2018 at 04:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation List - Formula to Sort and Return Unique Values in List
    By beewketu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2015, 04:18 PM
  2. vlookup to return data validation list of contact information
    By shingudaze in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2014, 03:37 PM
  3. [SOLVED] Data Validation List to Return Variable/Dynamic Data based on Reference Table
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2014, 09:08 AM
  4. Replies: 1
    Last Post: 06-19-2013, 07:02 PM
  5. Replies: 4
    Last Post: 04-11-2013, 12:18 PM
  6. Data Validation Drop-Down List Text Size
    By warrior2411 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2013, 01:17 PM

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