Forum Discussion

Brass Contributor

Feb 26, 2022

Let statement display multiple results in separate columns

Hello, Thanks to any one who can help. I Have a Let formula that pulls data from 3 separate sheets and stacks it in one column on a separate sheet. I also want to add another variable to the let for...

Excel

Formulas and Functions

office 365

HansVogelaar

MVP

dshawSLDC

For example:

=LET(
List,CHOOSE({1,2,3,4,5,6,7},EducationData!B72:B239,EducationData!C72:C239,EducationData!E72:E239,EducationData!F72:F239,EducationData!G72:G239,EducationData!H72:H239,EducationData!J72:J239),
ListEmp,SORT(IF(ISBLANK(List),"Empty",List),1,1),
ListCol,INDEX(ListEmp,,3),
ListCol)

dshawSLDC

Brass Contributor

Feb 28, 2022

Thanks That was very helpful. Quick question do you know if you can use the choose statement on array?

HansVogelaar
MVP
Feb 28, 2022
dshawSLDC

Not sure what you mean.

The syntax of CHOOSE is CHOOSE(index, value1, value2 ,...)

CHOOSE({1,2}, array1, array2) works, but CHOOSE({1,2}, array) doesn't.