Forum Discussion
Solved
Returning row and column value in a large chart if column is in a range
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 retur...
Second MATCH could be like
=MATCH(W3,D3:R3,-1)+1
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.
Hope this helps!!
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.
Hope this helps!!