cascading dropdown with 2 values to prepopulate (also in Quip)

Hi all,

My name is Monika from Germany. I am hoping someone can help with a formula and possibly with Quip conversion.

I have created a cascading dropdown in Excel on sheet Selection. It reads from sheet DD. I have 2 issues:

1) On two occasions, there is only one sub-selection possible, so I would like to adjust the formula, that if the selection is made, it prepopulates the corresponding value in column M, i.e., when "N/A (comment)" is selected in column L, "N/A (comment)" is automatically filled in in column M. I tried a bunch of IFS and IF(ANDs but everything fails.

2) When it works, is there a way to put that into a Quip? The formula that works in Excel, isn't recognized in Quip. Maybe other functions would accomplish that? Quip seems very limited.

Any help would be much appreciated.

Quip is a practically useless, washed down version of Excel from Salesforce with a limited number of functions.

Hi Jete, I am making progress and =INDEX(Selection!$L2:$L7,COLUMNS($F2:F2)) works for the headers. =FILTER($A2:$A19,$A2:$A19) works for list on the DD sheet. But when I put =FILTER($A2:$A19,$A2:$A19=F1) quip throws an error. I got to get back to work now, but I will try to make that work in Excel so I can upload a new doc for verification, ok? Many many thanks.