Populate Data Based On Changing Criteria

Hi,

I have a data in Sheet 1. I have a summary table in sheet 2 in which I have a drop down menu in cell C2. When I choose the branch name in cell C2, I would like the data for that branch to populate in cell C3 to C5 based on the data in sheet 1.

Is this possible?

I have a cross post here:

http://www.mrexcel.com/forum/excel-q...-criteria.html