Hi All,
This is my first time at this so bare with me as I attempt to explain my problem.
I am using a Borehole (BH) Logging software where I can export my data into an Excel file from Access. Attached are the two tables that I am working with. The first is called 'Samples' which is a list of samples taken from specific BH at specific depths. The second 'Lithology' which is the depth range of lithologies in each BH. I want the spread sheet to determine what lithology the sample is located in for a specific BH. If the sample was taken from BH 19-B01 at 0.75 m, then on the lithology sheet it should look up BH 19-B01, compare 0.75 m to the depth range of the lithology, and then report the lithology in the sample sheet and do it for the correct borehole every time.
I have no problem executing this for a single BH using some different functions (index/match, vlookup, lookup), currently I use this in the "I" column of the samples tab =LOOKUP(C2,Lithology!$F$2:$F$5,Lithology!$H$2:$H$5), but I run into an issue once my borehole number changes. I've tried nesting multiple lookup and if functions and am getting lost in the logic. It is becoming monotonous to adjust the above formula, and I am looking for something that I can drag down the data set without adjusting the formula.
I had a hard time explaining what I trying to do, but if you can take a look at the file it might clear some things up. Please let me know if you have any further questions.
Thanks!
Kyle
Bookmarks