Can't Export Google Sheets to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2986785%22%20slang%3D%22en-US%22%3ECan't%20Export%20Google%20Sheets%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2986785%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3EI%20am%20trying%20to%20import%20a%20google%20sheets%20file%20to%20excel%2C%26nbsp%3B%20but%20my%20formulas%20are%20not%20translating.%3C%2FP%3E%3CP%3EI%20know%20arrayformula%20does%20not%20work%20with%20Excel%2C%20but%20I%20cannot%20find%20the%20equivalent.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20formula%20in%20Google%20Sheets%20is%26nbsp%3B%20%26nbsp%3B%3DIFERROR(sort(unique(arrayformula(VLOOKUP(A1%3AA%2CB1%3AB%2C%3CSPAN%3E1%3C%2FSPAN%3E%2C%3CSPAN%3EFALSE%3C%2FSPAN%3E))))%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20showing%20up%20in%20Excel%20is%26nbsp%3B%3DIFERROR(%40__xludf.DUMMYFUNCTION(%22IFERROR(sort(unique(arrayformula(VLOOKUP(A1%3AA1442%2CB1%3AB1442%2C1%2CFALSE))))%2C%22%22%22%22)%22)%2C%22Both%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2986785%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2986879%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Export%20Google%20Sheets%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2986879%22%20slang%3D%22en-US%22%3EArray%20functionality%20is%20in%20Excel%20365%20so%20just%20drop%20%22arrayformula%22%20and%20try%20again.%20Should%20be%20something%20like%3A%3CBR%20%2F%3E%3DIFERROR(sort(unique(VLOOKUP(A%3AA%2CB%3AB%2C1%2CFALSE)))%2C%22%22)%3C%2FLINGO-BODY%3E
Occasional Visitor
 

I am trying to import a google sheets file to excel,  but my formulas are not translating.

I know arrayformula does not work with Excel, but I cannot find the equivalent.

 

My formula in Google Sheets is   =IFERROR(sort(unique(arrayformula(VLOOKUP(A1:A,B1:B,1,FALSE)))),"")

 

What is showing up in Excel is =IFERROR(@__xludf.DUMMYFUNCTION("IFERROR(sort(unique(arrayformula(VLOOKUP(A1:A1442,B1:B1442,1,FALSE)))),"""")"),"Both")

 

Thank You in advance!

 

2 Replies
Array functionality is in Excel 365 so just drop "arrayformula" and try again. Should be something like:
=IFERROR(sort(unique(VLOOKUP(A:A,B:B,1,FALSE))),"")

@user_1214 

As variant that could be

=SORT( UNIQUE( FILTER(B1:B1442, COUNTIF(A1:A1442,B1:B1442) ) ) )

VLOOKUP() is not the best option working with dynamic arrays