Looking up a worksheet and value

J

jtfalk

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.
 
B

Bernie Deitrick

=COUNTIF(INDIRECT("'" & A1 & "'!$D$4:$D$1817"),D2)
HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Horizontal and Vertical lookup 2
Row references 1
Formula for looking up and copying from another worksheet? 1
Multiply with Vlookup value from another Worksheet 0
Match a value to multple criteria both in rows and columns 3

Top