I am unable to understand issue here

Copper Contributor

After taking help for Microsoft Community I prepared a worksheet so facilitate my work. Everything works fine in Excel without any issues whatsoever.




But when I import same excel sheet to google sheets, I get error as below



Please help me out on this 


4 Replies

@Ramu2603 The link gives "Unauthorized", so please send one that gives full access.


Then, Excel is NOT Google sheets. Although some formulas may work the same, others will not. What formula is in the cells that return the Value error?

Above is the One Drive link for the same excel file

And below is the formula which shows error in Google Sheets
"=ARRAY_CONSTRAIN(ARRAYFORMULA(SUMPRODUCT(('Master-Sheet'!$H$2:$H$2000:'Master-Sheet'!$H$2:$H$2000='Backend Data'!$K$4)*('Master-Sheet'!$M$2:$M$2000:'Master-Sheet'!$M$2:$M$2000='Backend Data'!$M$3))), 1, 1)"

@Ramu2603 Well, I can't help you with that as I don't know anything about GS. Sorry.

Thanks for taking a look @Riny van Eekelen .