Forum Discussion
Google Sheets download to Excel
I have a fairly large file I download from Google sheets to Excel and have an issue with this formula not pulling through: =IFERROR(ifs($B$3="Department View",INDEX('Budget YTD'!$D$14:$P$77,MATCH($B...
Curly brackets means that formula is returned as array formula (and your Excel version doesn't support dynamic arrays). To enter such formula use Ctrl+Shift+Enter instead of Enter.