Find max date and return value for item

[christine2187]

I have part numbers with multiple invoices over the past year. I need to find the last invoice date for each item and return the invoice amount for that date.
I managed the =MAX(IF($A$2:$A$9430=A9433,$B$2:$B$9430)) formula to find the date...but I'm stuck as to how to add a command to return the value associated with that date. Any help would be great

[Glenn Kennedy]

Array formula in F2, to return a list of items:
=IFERROR(INDEX($A$2:$A$29,MATCH(0,INDEX(COUNTIF($F$1:$F1,$A$2:$A$29),0),0)),"")

Array formula in G2, to return the latest date:
=IF(F2="","",MAX(IF($A$2:$A$29=F2,$B$2:$B$29)))

Array formula in H2, to return corresponding value:
=IF(F2="","",INDEX($C$2:$C$29,MATCH(1,($A$2:$A$29=F2)*($B$2:$B$29=G2),0)))

[Glenn Kennedy]

I was too quick to post....

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

[christine2187]

That worked! Thank you so much!!!

[Glenn Kennedy]

No problem!! thanks for the rep.