I'm attempting to set up a multi-conditional lookup (table 2) that can identify the value for which the adjacent lower and upper latitude and longitude (table 1) values fall between the input (C20 - F20) upper and lower latitude and longitude boundaries (table 2), OR, if there are multiple values with longitude and latitude coordinates that fall between the input boundaries to give the average of these values.
The ultimate purpose of these calculations is to produce raster arrays (such as you would find in a geographical information system like ArcGIS) in excel using coordinates and values alone, structured like table 3.
Note: for the purpose of simplicity I've just used simple values rather than longitude/latitude or eastings/northings
Bookmarks