I would like to search a value in a matrix, normally I combine index & match function only this time there are multiple columns with characteristics
I think this can be done with the formula productsum but I do not know exacly how.
I also added a small example see attachment
So if Column A is Appel, column B is one, and Column C is Erik and row is 1 june, what is the corresponding number out of the matrix?
I hope somebody can help me.
Thanks!
Bookmarks