Retrieving a value based on Three Variables

Discussion created by dawson345 on Mar 12, 2014
Latest reply on Mar 17, 2014 by dawson345



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 ZoneSlopeOrentation Zero DegreesOrentation Five Degrees (etc.)
Zone 10776546
Zone 11678678

Zone 20678654



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.


Please help!