Hi all.

I am trying to Auto Replacing Absolute Reference Cells with a Row of Data to Obtain Different Output.

I have a range of data which represents a volume (Column A) which is defined by its East, North, and Up coordinates.
Column C defines the minimum of East, Column D the minimum of North coordinates, Column E the minimum of Up coordinates, Column F the maximum of East coordinates, Column G the max North coordinates and Column H the maximum Up coordinates.

So for example, area KSF_0106 has a boundary of:

43850 <= East <= 63850,
159000 <= North <= 173250,
37500 <= Up <= 86000.

So when I input the 3 coordinates for East, North and Up into cells $L$4, $M$4, and $N$4 (Blue Cells), I would get the corresponding Area (Column A) which satisfies the 3 coordinates (output = Green Cell.

You can refer to the attached file to see what I'm trying to do.

Right now my formula is referencing cells $L$4, $M$4, and $N$4 to obtain the output value(green coloured cell).

What I would like to do is to make a formula/VBA to replace/loop the referencing cells $L$4, $M$4, and $N$4 with the list of values I have stored in Columns S,T,U and get its corresponding output (Area).

Right now the sample has 66 coordinates, but I would like to be able to run over 1000+ coordinates to find its corresponding volume.

Right now what I'm doing is keying in every value to obtain its output, and this obviously is time consuming.


Appreciate the help if there is a VBA or formula to ease this tedious process. Also note that there might be negative values as well. Also I know my formulas might be messed up/impractical way, so please be nice! :P

Btw I have a problem with uploading files so here is the link to my excel file:
<a href=http://www.filedropper.com/testfile_9><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >share files free</a></div>

http://www.filedropper.com/testfile_9

Thanks a lot.