Forum Discussion

Luc_de_Jong's avatar
Luc_de_Jong
Copper Contributor
May 25, 2020

A question about dropdown lists

I have a question about dropdown lists. I want to make 3 dropdown lists (the last one dependent). Cell A12 and B12 are both drop down lists (not dependent). In the drop down list I have the opt...
excel
Jos_Woolley's avatar
Jos_Woolley
Iron Contributor
May 25, 2020

Luc_de_Jong 

 

Hi,

 

In C12:

 

=T(HLOOKUP(B$12,INDEX($3:$3,MATCH(A$12,$2:$2,0)):K$100,ROWS($1:2),0))

 

and copied down until you start to get blanks for the results.

 

Regards

Resources