Forum Discussion
Solved
Two Dimensional Range Lookup: Error
Hello all, I am using this formula, associated with the picture below: =INDEX(Sheet2!$D$3:$F$5,MATCH(J2,Sheet2!$C$3:$C$5,0),MATCH(K2,Sheet2!$D$2:$F$2,0)) What am I doing wrong? The ...
Thanks! The problem is that E2 on Sheet2 contains "Lateral " with a space at the end. If you remove the space, the formula on the Raw Data sheet will work as intended.
File is attached. Please let me know if you can not view. Thank you!
Thanks! The problem is that E2 on Sheet2 contains "Lateral " with a space at the end. If you remove the space, the formula on the Raw Data sheet will work as intended.
- omg. Thank you!