Excel 2007 : Some Form Of VLookup type function....

Hi,

What a wonderfull resource this site is, and firstly I would like to thank all of the posters that have helped me with responces to others problems over the years.

I today come with a problem that is really getting to me. Generally I can go throught the lists with a fair degree of success without asking for peoples help... this issue however, is much to far out of my legue of knowledge.... I turn to you guys who appear to have answers for everything!!!!

I am trying to do a VLOOKUP with some data, based on a series of parameters...

Firstly i need it to pick up the name of the drill hole, then lookup the interval that matches between the data in the lookup table... Then report out the seam....

More description in the excel file.....

Excel Help Forum... You are my only hope!