Forum Discussion
xlookup
Hi All I am really new to this so apologize but i am trying to add up a list of values based on 3 criteria's using the below formula and it is returning a value error but if i take out the 3 criteri...
The TRANSPOSE must be wrong! I suspect you should be using two XLOOKUPS. The first restricts the search to a column and the second searches within it for the cell to return.
= XLOOKUP(
Apr!E2,
Apr!$K$5:$K$22,
XLOOKUP(
1,
(Apr!$N$2:$AG$2=Apr!A2)*(Apr!$N$4:$AG$4=Apr!$F$1),
Apr!$N$5:$AG$22
)
)