Display range based on cell value

I have a single sheet (see Image or attachment)

What I want to do is have the values in cells D11 and D12 propogated automatically from the table above it based on the month specified in cell B1

I've completed the sheet for March as an example.

Any help would be appreciated.

Hi
For your example try:
for Sales: =HLOOKUP($B$1,$D$3:$I$5,2,0)
for Refunds: =HLOOKUP($B$1,$D$3:$I$5,3,0)

Hope this helps!
JG

Many Thanks, that worked a treat!

Just a quick question, why do you put the dollar ($) sign in front of the cell reference?

Thanks again.

Hi
You're welcome.

The $ sign is to make the cell reference obsolute meaning it will not change if you pasted the formula across or down. You can also make either the row or column obsolute by putting the $ sign in front of it... i.e =$A1 or A$1
You should learn how to use this as it is very helpful when working with formulas, saves a lot of typing.

Regards
Jean-Guy