I'm trying to perform a lookup that needs to meet multiple criteria, and can't get it to work. As you see on the attached example, I have to lookup the value at the intersection of three column headers matching certain criteria, and one matching row criteria. I'm thinking it needs to be a nested XLookup, but I need help on this one. Thanks in advance.
Bookmarks