Multiple If function with arrays

Hi

I have been trying to figure what I'm been doing wrong.

I have IF Functions within IF Functions, where the criterias are based on several ranges. I have made the formula into an array.

But the formula only seems to work partially.

It's at bit difficult to explain so I've made and example workbook, where I describe and illustrate the problem.

Thanks for helping

I can't understand the logic: table on the right is based last month dates yet your requirement is based on this months dates.

Please add some sample output, explaining how you calculated it.

I think the answer is INDEX/MATCH.

Hi
Try this regular formula in F16

Formula:

Please Login or Register  to view this content.

.... think I have it!!!

Try

in F16 and copy down

=IF(AND([@Dato]>=$C$13,[@Dato]<=$D$13),INDEX($N$9:$Q$13,MATCH($C16,$M$9:$M$13,0),MATCH($B16,$N$8:$Q$8,0)),"")

Thank you both

Both of the formulas works perfectly

I would never have thought of that solution.

Thank you for the feedback and rep.

I make mine the words of JohnTopley. Thanks.