I have set up a database which includes a survey form for Solar PV installations. I need to retrieve a value based upon three factors (Postcode Zone, Orientation and pitch) I have placed the data in a table with the following format:
|Postcode Zone||Slope||Orentation Zero Degrees||Orentation Five Degrees (etc.)|
I am happy to change the way this is stored, the original file is here - Irradiance Datasets
I have the three search terms ready but I am having trouble finding the feature to search and retrieve the value required for my calculation.