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).
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Material[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[/TR]
[TR]
[TD]Chem A[/TD]
[TD]234[/TD]
[TD]235[/TD]
[TD]235[/TD]
[TD]677[/TD]
[/TR]
[TR]
[TD]Chem B[/TD]
[TD]235[/TD]
[TD]235[/TD]
[TD]463[/TD]
[TD]368[/TD]
[/TR]
</tbody>[/TABLE]


On a sheet named Usage, a list of the chem with usage next to it. Above is a dropdown box.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Drop down box here with months[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chem A[/TD]
[TD]Usage[/TD]
[/TR]
[TR]
[TD]Chem B[/TD]
[TD]Usage[/TD]
[/TR]
[TR]
[TD]Chem C[/TD]
[TD]Usage[/TD]
[/TR]
</tbody>[/TABLE]

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,),)