Two Dimensional Range Lookup: Error

Brass Contributor

Hello all,


I am using this formula, associated with the picture below:





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)






6 Replies
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?

File is attached. Please let me know if you can not view. Thank you!
best response confirmed by kittenmeants (Brass Contributor)


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!