<div>
<div class="content wysiwyg-content">
Ok, I'm trying to set up a table that pulling out hours values for employees on certain projects by month. I have all the data, now I just need to build a graph depending on which employee is selected in a drop down on a worksheet. &nbsp;the employee's name is the header of the column the data will need to be indexed from in the data tables. 
 
=INDEX(ResourceLoading[Jane Doe],MATCH('Reports 1'!K2,ResourceLoading[Month])) 
 
Basically I need &quot;Jane Doe&quot; in that formula to be whatever the value of the drop down in Cell: J2 is. I know it has to be simple, but the life of me I can't figure out how to get it to work. 
 
I've tried =INDIRECT(&quot;=INDEX(LoadingActual[&quot;&amp;J2&amp;&quot;],MATCH('Reports 1'!K2,LoadingActual[Month]))&quot;) 
 
To no avail. 
It evaluates out to #Ref, but while evaluating it seems to show the correct formula: =INDIRECT(&quot;=INDEX(ResourceLoading[Jane Doe],MATCH('Reports 1'!K2,ResourceLoading[Month]))&quot;) 
 
I'm guessing the inverted comma's are what's bugging it?
</div>
</div>

Ok, I'm trying to set up a table that pulling out hours values for employees on certain projects by month. I have all the data, now I just need to build a graph depending on which employee is selected in a drop down on a worksheet.  the employee's name is the header of the column the data will need to be indexed from in the data tables.

=INDEX(ResourceLoading[Jane Doe],MATCH('Reports 1'!K2,ResourceLoading[Month]))

Basically I need "Jane Doe" in that formula to be whatever the value of the drop down in Cell: J2 is. I know it has to be simple, but the life of me I can't figure out how to get it to work.

I've tried =INDIRECT("=INDEX(LoadingActual["&J2&"],MATCH('Reports 1'!K2,LoadingActual[Month]))")

To no avail.
It evaluates out to #Ref, but while evaluating it seems to show the correct formula: =INDIRECT("=INDEX(ResourceLoading[Jane Doe],MATCH('Reports 1'!K2,ResourceLoading[Month]))")

I'm guessing the inverted comma's are what's bugging it?

Index(xxx,Match(xx)) Formula where index range is variable set by a drop down.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.