Forum Discussion
bullsgame1
Oct 12, 2022Copper Contributor
Looking up a Horizontal and Vertical value to find a total amount
Hey Everyone, I am trying to write a function that will look up a horizontal and its corresponding vertical value in the matrix to find a total amount paid in another sheet. 2 criteria's have to be...
Patrick2788
Oct 12, 2022Silver Contributor
You could use a double XLOOKUP:
https://exceljet.net/formula/xlookup-two-way-exact-match
https://exceljet.net/formula/xlookup-two-way-exact-match