| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up a worksheet and value
I am trying to have a graph set up to look at 1 of 18 worksheets to get the
numbers and graph it. Currently I have this for populatiing the numbers D2 = week 1 =COUNTIF('Dept. 1'!$D$4:$D$1817,D2) I have made a drop down that has Dept. 1 trough 18 in cell A1. I would like to have the statement be that which would look at A1 and pull the column D values from the cooresponding worksheet to A1. Any help would be appreciated. =COUNTIF('A1'!$D$4:$D$1817,D2) - does not work because there is no A1 woorksheet. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking up a worksheet and value
=COUNTIF(INDIRECT("'" & A1 & "'!$D$4:$D$1817"),D2)
HTH, Bernie MS Excel MVP "jtfalk" wrote in message ... I am trying to have a graph set up to look at 1 of 18 worksheets to get the numbers and graph it. Currently I have this for populatiing the numbers D2 = week 1 =COUNTIF('Dept. 1'!$D$4:$D$1817,D2) I have made a drop down that has Dept. 1 trough 18 in cell A1. I would like to have the statement be that which would look at A1 and pull the column D values from the cooresponding worksheet to A1. Any help would be appreciated. =COUNTIF('A1'!$D$4:$D$1817,D2) - does not work because there is no A1 woorksheet. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking up a worksheet and value
Try the below
=COUNTIF(INDIRECT(A1&"!D4:D1817"),D2) "jtfalk" wrote: I am trying to have a graph set up to look at 1 of 18 worksheets to get the numbers and graph it. Currently I have this for populatiing the numbers D2 = week 1 =COUNTIF('Dept. 1'!$D$4:$D$1817,D2) I have made a drop down that has Dept. 1 trough 18 in cell A1. I would like to have the statement be that which would look at A1 and pull the column D values from the cooresponding worksheet to A1. Any help would be appreciated. =COUNTIF('A1'!$D$4:$D$1817,D2) - does not work because there is no A1 woorksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
