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 data from column E is not being captured in the output. (i.e. Green-Lateral will not populate as Critical)
Thanks!
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 leading or trailing spaces anywhere? Have you tried selecting both MATCH functions in the formula and press F9 to see what they yield? (make sure you press Escape rather than enter)
- 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?
