Results 1 to 4 of 4

Indirect Formula to report content based on two previous columns?

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    16

    Indirect Formula to report content based on two previous columns?

    I’ve recently made changes to my Validation sheet to allow for dynamic name ranges and future expansions in my data.

    The problem that I’m having after trying several options is that the indirect formula found in my Source Data Sheet, Table A, Description Colum Data Validation, is not working. What I’m currently using is;

    =INDIRECT(SUBSTITUTE(D16," ",)&SUBSTITUTE(E16," ",)&"List")

    The formulas intent is to report back a specific list of descriptions based on the selections made by the user in the STAGE and CATEGORY columns.

    Any help is appreciated and file is attached.

    Many thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Correct formula for adding columns based on previous row
    By packers316 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-02-2013, 06:44 AM
  2. [SOLVED] Creating a variable length report based on criteria in previous worksheet
    By lizziebusy in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-05-2012, 03:00 PM
  3. [SOLVED] Need to select/report all rows based on content
    By Kristin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2006, 02:00 PM
  4. [SOLVED] Create a report with selected rows based on the content in a cell
    By ThirdTim in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-05-2005, 01:06 PM
  5. [SOLVED] Hide Cell Content if no data in previous columns
    By Sherry in forum Excel General
    Replies: 4
    Last Post: 02-21-2005, 04:06 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