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,...
Possibly (You may adjust the ranges to accommodate your data):
=LET(f,FILTER('TAB1'!A2:K5,'TAB1'!G2:G5<>" "),INDEX(f,SEQUENCE(ROWS(f)),{1,3,4,10,11}))