Excel 2007 : Lookup Data Using Drop Down Menus

Afternoon all,

Is it possible to look up data using drop down menus? I've attached an example of what i'm trying to achieve. I'd like to be able to change the drop downs in cells A1 and B1 and pull through the data from the relevant tab into cells B2 to B4.

Thanks in advance,

Snook