1 Attachment(s)
Extract and Copy Data from an Array to a Cell with Criteria
Dear friends, I hope you are well.
Attachment 31455
What function or combination of functions should you use to be able to extract solely and exclusively those Data contained in the Ranges Índice "A" (MATRIZ2!$L$2:$L$2138), Índice "B" (MATRIZ2!$M$2: $M $2138 ), Índice "C" (MATRIZ2!$N$2:$N$2138) and Índice "D" (MATRIZ2!$O$2:$O$2138) of Sheet 4 (MATRIZ2) that meet the Year Criteria (MATRIZ2 !$ B$2:$B$2138;$H$6) and Month (MATRIZ2!$C$2:$C$2138;D$10) whose results can then be automatically copied to Sheet 10 (INDICES):
INDICE A - 2000 = D$11 Up to O$11
INDICE B - 2000 = D$18 Up to O$18
INDICE C - 2000 = D$25 Up to O$25
INDICE D - 2000 = D$32 Up to O$32
I will be very grateful for any guidance you can give me.