Forum Discussion
Convert from Google Sheets using IFERROR not working
Asking the experts why a formula working in Google Sheets fails to work in an Excel file that has been downloaded? Here is the formula working in Sheets: =IFERROR(Query('TAB1'!A2:K,"Select A,C,D,...
Just a s a reminder, the Google sheet code changed to the following in the Excel file:
=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(Query('1. Outlining the Course'!A2:K26,""Select A,C,D,J,K where G <>'' "",1),""No records found"")"),"Standard")
=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(Query('1. Outlining the Course'!A2:K26,""Select A,C,D,J,K where G <>'' "",1),""No records found"")"),"Standard")
jenniferk007 Going back to you original question and mtarler 's first response. Google Sheets and Excel are NOT the same. When you say that you open a Google sheets document in Excel, fair chance that Excel doesn't know what to do with it. Query, select and where are not an Excel functions, hence the "__xludf.DUMMYFUNCTION" part that Excel puts into the formula. You have to re-write it with valid Excel functions. I believe that's what Mat tried to do for you. Your Excel for Mac version 16.57 should support all the functions he used. But you can check that by entering =FILT or =SEQU. Excel should prompt the FILTER or SEQUENCE function. If not, then your version can't use Mat's formula.