I am looking for help with creating a lookup formula with multiple
conditions. In Sheet1 I have the following table with B2:E2 being the header
row.

B2 C2 D2 E2
B2 Region Type Jan-09 Jan-09
B3 Central Hrs 2 3
B4 Central $'s 9.85 12.78
B5 East Hrs 4 5
B6 East $'s 27.18 65.24
B7 West Hrs 1 1
B8 West $'s 4.48 4.98

On another worksheet (Sheet2), I am looking for a lookup formula to get the
following table. I would like to use a dynamic lookup formula to MATCH the
column month in a range (Sheet1!B2:E2), then lookup ONLY the cell values that
have a "$'s" value in Type column (Col C).

BU Jan-09 Feb-09
Central 9.85 12.78
East 27.18 65.24
West 4.48 4.98

Can this be done by a VLOOKUP with a MATCH function?? Thanks!