+ Reply to Thread
Results 1 to 1 of 1

Indirect function to pull desired no of cells/row data based on data validation in Input

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,248

    Indirect function to pull desired no of cells/row data based on data validation in Input

    Dear Sir,

    As enclosed workbook for your kind reference, my problem is that I want to pull data in sheet 'Output!B5' onwards based on the condition of Output!C1,Output!C2 & Output!C3:F3.There is data validation in 'Input 'Sheet in C2 & C3 and upon changing corresponding data in Output sheet changes from C1:F3.

    Here,if condition of Output!C3:F3 is not blank than how to readjust my formula in Output!B5 onwards,so that there would be unique name in Output!B5 onwards cells/rows and no duplicates.But if in Output!C3 is not blank than Output!B5 onwards should display only data that is of Output!C3 from the specific sheet that is reflecting in Output!C1 cell.In summary,

    If Output!C3 is only visible >>Then >>Output!B5 onwards cells/row display only that contains Output!C3 data from specific sheet mentioned in Output!C1
    If Output!D3 is only visible >>Then >>Output!B5 onwards cells/row display only that contains Output!D3 data from specific sheet mentioned in Output!C1
    If Output!E3 is only visible >>Then >>Output!B5 onwards cells/row display only that contains Output!E3 data from specific sheet mentioned in Output!C1
    If Output!F3 is only visible >>Then >>Output!B5 onwards cells/row display only that contains Output!F3 data from specific sheet mentioned in Output!C1
    If Output!C3:F3 is visible >>Then >>Output!B5 onwards cells/row display only the unique values with no duplicates that contains Output!C3:F3 data from specific sheet mentioned in Output!C1

    Hope you have understood,what I mean to say.You can re arrange data inorder to arrive desired result.

    If you require any further info then do let me know.

    With Best Rgds,
    Suresh
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Input box for indirect data validation
    By garmelvin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2013, 10:43 AM
  2. Pull Data from Multiple Columns Based On Data Validation List Selection
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:41 PM
  3. [SOLVED] Help with Data Validation using INDIRECT function
    By ddub25 in forum Excel General
    Replies: 7
    Last Post: 07-14-2012, 08:33 AM
  4. INDIRECT function and data validation
    By penguintar in forum Excel General
    Replies: 2
    Last Post: 03-23-2011, 04:02 PM
  5. Excel 2007 : Pull Data from Cells based upon User Input
    By FLEXCopMNPD in forum Excel General
    Replies: 2
    Last Post: 02-23-2010, 12:02 AM

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