I'm wondering if anyone can help me with this. This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values. I want to find the intersection value returned to a cell of my choosing. But the catch is that the column values are in a range from the column farthest out value is the low number, to the previous column value being the lowest range to jump into the next column of values. I've tried VLOOKUP, coupled with INDEX / MATCH, and I still can't seem to get a handle on this. I tried
Hi Orin, The Index-Match formula you proposed looks as if it should work. I would manually test to ensure that the values are actually matching. For example, use another free cell to ensure that V3 is equal to C27, by just entering "=V3=C27"
If this checks out for both the values you are attempting to match, try debugging the pieces of your formula by selecting each argument of the Index function and evaluating in the formula editor by pressing F9. This can help you determine where the actual error is occuring in nested functions.
Many thanks to you good sir for helping me out on this. Now its on to referencing this workbook from another one whilst changing the lookup cells to the other workbook. No doubt a mere drop in the bucket for one such as yourself. :) Thanks again.