Hi there,
I have an Excel formula that I would like to calculate in Google Sheets instead of Excel (for data architecture purposes), but unfortunately it does not work on Google Sheets as-is
I have made some research / tried some alternative formulas but I haven't been able to find any solution so far.
Any idea how I can make the below calculation in Google Sheets?
I have built a dummy Google Sheet and highlighted in yellow the cells in which this formula should be calculated - feel free to play with it
.
Thanks so much for your help!
Cheers,
Larry
I have an Excel formula that I would like to calculate in Google Sheets instead of Excel (for data architecture purposes), but unfortunately it does not work on Google Sheets as-is

I have made some research / tried some alternative formulas but I haven't been able to find any solution so far.
Any idea how I can make the below calculation in Google Sheets?
Code:
INDEX(Transactions[Incoming Payment Date],MATCH(1,(Transactions[Marketplace]=[@Marketplace])*(Transactions[Spend From]<=[@[Cumulative Spend]])*(Transactions[Spend To]>[@[Cumulative Spend]]),0))
I have built a dummy Google Sheet and highlighted in yellow the cells in which this formula should be calculated - feel free to play with it

Thanks so much for your help!
Cheers,
Larry