VLookup/Match/Offset

[BoRed79]

Dear All.

Please could someone help me with a query that I have.

I have a spreadsheet, which on one sheet contains a whole load of data by
region, which I am trying to summarise.

On another sheet I have set up a summary table that I want to populate,
depending on the region that I am interested in.

I have created some dependent drop downs, so that it would allow me to
select the region that I am interested in.

I want to be able to select the region from the drop down and it
autopopulate the summary table with the information from that region.

I am not sure which function/combination of functions I should use to do
this though.

Any ideas would be welcomed.

Thanks.

 

[Pete_UK]

One way would be to apply autofilter to your data to select the region
you are interested in. If necessary, you can copy the visible data to
another sheet.

Hope this helps.

Pete