Two Dimensional Range Lookup: Error

[kittenmeants]

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!

[#2]

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)

[#3]

No spaces, double checked that. Both yield '#N/A'.

[#4]

@kittenmeants 

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?

[#5]

File is attached. Please let me know if you can not view. Thank you!

[#6 · Accepted solution]

@kittenmeants 

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.

[#7]

omg. Thank you!