azumi yes I'm looking to get the result from column F in sheet 1, with the criteria searched 'Area' or 'Site'(both of these will be on the same drop down menu), this search will then populate against the 'KPI' and 'Month'.