i have a list made in the grey cell , it has two options "adv" or "dis" each choice has contents , i want to fill the selected cells with the contents of the chosen option

CodePudding user response：

So use an if() like so, entered in cell L2:

=if(H$4="dis",J2,k2)

Then drag down, this assumes that H4 is the control for all cells.