Paid 2 Heat
New Member
Good afternoon,
I have a workbook containing many worksheets (20+). Each worksheet contains solar irradiance data based on given postcode regions within the UK.
The lookups for each postcode region are based on: angle of roof (column A) and deviation from South (Row 1). This intersection lookup is not a problem.
I should like to find a solution so that, for example, if the UK postcode was entered as NE - ie Newcastle - the system would perform the intersection lookup in that particular worksheet only.
If I used independent named ranges for each of the 20+ postcode data sets, would a CHOOSE() work, based on the postcode cell reference in the data-entry worksheet?
Thank you in advance for your assistance.
I have a workbook containing many worksheets (20+). Each worksheet contains solar irradiance data based on given postcode regions within the UK.
The lookups for each postcode region are based on: angle of roof (column A) and deviation from South (Row 1). This intersection lookup is not a problem.
I should like to find a solution so that, for example, if the UK postcode was entered as NE - ie Newcastle - the system would perform the intersection lookup in that particular worksheet only.
If I used independent named ranges for each of the 20+ postcode data sets, would a CHOOSE() work, based on the postcode cell reference in the data-entry worksheet?
Thank you in advance for your assistance.