I'm trying to transition from Google Sheets to Office 365, and have some issues with converting certain formulas which seems to work differently.
I have a table containing a list of transactions, as well as some columns with different cumulative calculations for different types of products. Now I am trying to create another table containing one row for each product, which lookup the latest row in the first table and pull information from it.
In Google Sheets I have this working formula:
=iferror(INDEX(arrayformula(filter(F:F,D:D<>"",row(D:D)=max(if(D:D=A3,row(D:D),0)))) ,1),0)
Cell A3 contains the product name I want to lookup.
Column D contains the product name in the transactions table.
Column F contains the value I want to pull from that table.
Any suggestions on how I can convert the formula above to Excel? (I tried to include a link to a shared Google Sheet with a small example, but I'm not allowed to include links it seems.)
Bookmarks