Linking drop down box to lookup function

[koyangi87]

I have a table consisting of months across row 4 and material usage in columns C-AQ. On a separate sheet, I have a dropdown box with the months. What I'm trying to do is when I select a month, all the data for usage changes depending on the months.

On a sheet named Rolling Sums, a Table that looks like this (except much bigger).

Material	Jan	Feb	Mar	Apr
Chem A	234	235	235	677
Chem B	235	235	463	368

<tbody>
</tbody>

On a sheet named Usage, a list of the chem with usage next to it. Above is a dropdown box.

	Drop down box here with months
Chem A	Usage
Chem B	Usage
Chem C	Usage

<tbody>
</tbody>

Anyone willing to help me out? Since my array is in a row and my results are in a column, I'm not sure how to proceed.

 

[LxQ]

You can use something like this:
Let's say "Chem A" is in B5 on "Rolling Sums" and it's in A7 on "Usage"
Dropdown box in B6

=HLOOKUP($B$6,Rolling Sums!$C$4:$AQ$7,MATCH($A7,Rolling Sums!$B$4:$B$7,),)