Results 1 to 3 of 3

Thread: Using the "IF" formula to return a defined list

  1. #1

    Using the "IF" formula to return a defined list



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am working on a spreadsheet at work where I have two tables of information, and depending on the answer to a set question, will depend on the table that needs to be shown.

    I am trying to use an "IF" formula to return the lists, however this isn't working! Can anyone help?

    Cheers,
    Will

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps something like:

    =INDEX(IF(A1="X",$X$1:$Y$10,$Z$1:$AA$10),ROWS($A$1:$A1),COLUMNS($A$1:A$1))

    where A1 contains the answer that defines table, and X1:Y10 and Z1:AA10 contain the 2 tables to choose from.

    the formula when copied down and to next column will extract the 2 table columns.


  3. #3
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Hi Will. Suggest you upload a sample spreadsheet, or further describe what your data looks like and what you want to do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •