Forum Discussion

heatherguest's avatar
heatherguest
Copper Contributor
Sep 08, 2020

Dependent drop down after 1st line

Dependent drop down lists with multiple words - replicating the validation    Hi,    I am having trouble with dependent drop down lists. I managed to follow a tutorial here:    https://ww...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 08, 2020

heatherguest 

Using of absolute and relative references in data validation formula is not correct, if change on

=INDEX('Background Forms HM'!$A$2:$I$25,,MATCH($C2,'Background Forms HM'!$A$1:$I$1,0))

it will be like

  • heatherguest's avatar
    heatherguest
    Copper Contributor
    Sep 08, 2020

    SergeiBaklan  Thank you so much!!! i knew I was doing something wrong, I just could not figure it out! 

Resources