Forum Discussion

ineedhelp's avatar
ineedhelp
Copper Contributor
Aug 31, 2019
Solved

Creating a Form

I have a workbook of 30 different tabs and I need a summary chart on a separate tab that will have a drop down list with the names of each tab so that when one is selected, only the data from that sp...
BI & Data Analysis
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 31, 2019

    ineedhelp , okay, when in Summary tab

    stay on C2, on ribbon Data->Data validation, select list and add names of your tabs as here

    To count number of weekdays for the selected sheet in C3 formula

    =COUNTIF(INDIRECT("'" & $C$2 & "'!B:B"), $B3)

    and drag it down.

    To return value of the cell S77 in selected sheet in D3 

    =INDEX(INDIRECT("'" & $C$2 & "'!S:S"),76+ROW()-ROW($B$2))

    and drag it down.

     

    Sample is attached.

ineedhelp's avatar
ineedhelp
Copper Contributor
Sep 07, 2019

I tried editing the formula to put in the correct tab name and am getting #N/A

 

=INDEX('with dollar amount pick'!$DP:$DP,MATCH($C$1,'with dollar amount pick'!$A:$A,0))

 

This is what I adjusted the formula to say. 

Resources