SOLVED: XLookup w/ 2 criteria for row and 1 criteria for column

Hi,

I have a challenge that I have somewhat figured out, but it is not elegant. I suspect that there is a simpler formula to pull this off. (You will see that I have used rows 7 and 8 to do some calculations to pull this off.) I would appreciate your review and ideas.

Note that the user would enter criteria in cells D2, D3, and D4. And, based on these variables (D2 in column A, D3 in column B, and D4 in row 10) there is a factor in the table that should appear in cells D5.

Thanks for the help!
IGoCougsI

Hello! Try this formula in D5

Please Login or Register  to view this content.

Cell D5 formula

Formula:

Please Login or Register  to view this content.

OR

Formula:

Please Login or Register  to view this content.