Base on material code - find out latest P.O. date per project

Enter this array formula in C2, then copy down:

=INDEX(PO!$D$1:$D$1033, LARGE(IF(PO!$A$1:$A$1033&"-"&PO!$B$1:$B$1033=$A2&"-"&$B2,ROW(PO!$C$1:$C$1033), ""), 1))

...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 your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.


For this to work, make sure your PO sheet is properly sorted by column A, then column B, then column C, before you evaluate the results.

Hi JBEAUCAIRE

SIR, Thanks a lot for your prompt reply!!!!!

I thing its magic formula, what a wonderful formula is this…. Its work like…..SUPERB……

SIR you have brilliant knowledge, god bless you….

One slightly amendment can made. If possible, project code removed, I want the same data with base of material code only then what will the formula.

Thanks for helping me, and sharing valuable knowledge

Thanks

Amar K

Also an array formula:

=INDEX(PO!$D$1:$D$1033, LARGE(IF(PO!$B$1:$B$1033=$B2,ROW(PO!$C$1:$C$1033), ""), 1))