I think you need to make some choices.
1) An option would be to use only region targets and assign a region to each area.
2) A second option would be the inverse, use only area targets and assign a region to each area.
1 and 2) Either way, you appear to need to have a value for both region and area in each of your rows.
3) Another option would be to combine the area and region columns so that there is a single column that contains both the area values and the region values. In qlikview, you would then have a single list box to select areas or regions with their associated targets.
Your data structure does not appear to be functional in the excel file as provided.