Forum Discussion
Solved
Get a text value from a number range that falls within another range
Hi, I am new to excel and sorry in advance if this has been posted already, but I did not have any luck finding anything. Using the example attached, I am looking at borehole data of the subsurface ...
See the attached version. I moved the depth range to Sheet2. The formula in A2 on Sheet1 is
=VLOOKUP(C2,OFFSET(Sheet2!$B$1,MATCH(B2,Sheet2!A:A,0)-1,0,COUNTIF(Sheet2!A:A,B2),3),3)This has been filled down.
See the attached version. I moved the depth range to Sheet2. The formula in A2 on Sheet1 is
=VLOOKUP(C2,OFFSET(Sheet2!$B$1,MATCH(B2,Sheet2!A:A,0)-1,0,COUNTIF(Sheet2!A:A,B2),3),3)
This has been filled down.
HansVogelaar Thank you so much, that has worked brilliantly!