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 :confused: 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? INDEX(Transactions[Incoming Payment Date],MATCH(1,(Transactions[Marketplace]=[@Marketplace])*(Transactions[Spend From] [@[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 :biggrin:. Thanks so much for your help! Cheers, Larry

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel formula on Google Sheets

Thread starter cohlar
Start date Nov 18, 2018
Tags

excel formula google sheet sheets

cohlar

New Member

Nov 18, 2018

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?

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