Index, Match, Maxifs giving me the wrong result (Google Sheets)

Question

I use this formula in other sheets to get the latest value found, meeting a criteria set in another column. This time, it's repeating the value for the first match, although I got the criteria changing for each row.

Inventory Table

=arrayformula(IFERROR((INDEX('Inventory'!$A$7:$H;MATCH(maxifs('Inventory'!$B$7:$B;'Inventory'!$D$7:$D;$C7);'Inventory'!$B$7:$B;0);8));""))

I've tried all kinds of tweaks, but even so...

Thank you!

Antonio

player0 player0 · Accepted Answer · 2021-02-01T14:47:59

try:

=ARRAYFORMULA(IFNA(VLOOKUP(C7:C; 
 SORT({'Contagem - Estoque'!D7:D\
       'Contagem - Estoque'!H7:H\
       'Contagem - Estoque'!B7:B}; 3; 0); 2; 0)))

Index, Match, Maxifs giving me the wrong result (Google Sheets)

1 Answers