Help on combining formulas

[Dazzybeeguy]

I have a spreadsheet with this formula in say cell B6

=XLOOKUP(B5,Teams!C5:T5,Teams!C6:T30)

In another column I have

=FILTER(VSTACK(B6#),VSTACK(B6#)<>0)

How can I combine the two together so its all in cell B6

TIA

 

[saboh12617]

Hello, a proposition

=LET(tbl, VSTACK(XLOOKUP(B5,Teams!C5:T5,Teams!C6:T30)), FILTER(tbl, tbl<>0))

 

[Cubist]

What's the purpose of VSTACK?

 

[StephenCrump]

... although you don't need the VSTACK

 

[Dazzybeeguy]

=LET(tbl, VSTACK(XLOOKUP(B5,Teams!C5:T5,Teams!C6:T30)), FILTER(tbl, tbl<>0))

Thank you very much