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...
OliverScheurich
Oct 12, 2022Gold Contributor
Example 3 of this link should be similar to what you are looking for.
XMATCH function (microsoft.com)