+ Reply to Thread
Results 1 to 4 of 4

Multiple Data Validations and IF statements

  1. #1
    Registered User
    Join Date
    05-06-2013
    Location
    West Lothain
    MS-Off Ver
    Excel 2012
    Posts
    3

    Multiple Data Validations and IF statements

    Hi Guys,

    Basically what I'm wanting to do is add multiple IF statements to 3 cells within a spreadsheet.

    Cell A has a list of 6 outcomes via the validation and works fine.

    Cell B has around a choice of 30 outcomes which have been shorted via an IF statement relating to your answer at cell A.

    Cell C I want to have around 200 outcomes which again I want reduced via an IF statement relating to your answer at cell B.

    The problem I'm having is in relation to the amount of space I have to write the IF statement, basically I've ran out of room within the data validation.

    My question is,

    Can this be done?

    Is there a better way of doing this without designing an assess database?

    Cheers

    Neil

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Multiple Data Validations and IF statements

    This is very commonly done using dynamic named ranges..
    Elegant Simplicity............. Not Always

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Multiple Data Validations and IF statements

    Insted of IF statement use Vlookup function.

  4. #4
    Registered User
    Join Date
    05-06-2013
    Location
    West Lothain
    MS-Off Ver
    Excel 2012
    Posts
    3

    Re: Multiple Data Validations and IF statements

    Thanks guys,

    I used 'INDIRECT' and 'INDIRECT SUBSTITUTE' in the end,

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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