• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

This is regarding Extracting data with duplicate lookup value

M

MBS

Member
Hi All,
I want to Pull data in Sheet name "consolidated" from either sheet, "A", "B" or "C", based on selection. Also, selection criterial is dates.
I want to use table referencing (as data in sheet A, B & C is in table format only) to extract data in consolidation sheet from either of sheet selected and based on date range.

Please suggest.
 

Attachments

  • Sheet Consolidation.xlsx
    15.8 KB · Views: 4
In cell B5:
Code: 
=LET(a,INDIRECT("Table" & E1),f,IF(ISBLANK(a),"",a),b,INDEX(a,0,1),c,b>=C1,d,b<=C2,FILTER(f,c*d,"none"))
or a bit shorter:
Code: 
=LET(a,INDIRECT("Table" & E1),c,IF(ISBLANK(a),"",a),b,INDEX(a,0,1),FILTER(c,(b>=C1)*(b<=C2),"none"))
 
Last edited:
You must log in or register to reply here.
Back
Top