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.
No spaces, double checked that. Both yield '#N/A'.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- 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!