Hi there,

I am using this formula in the range field of a drop down list to define multiple ranges for the list that are dependant on the choice made in a previous drop down list:

=
IF($B$8=$F$3,$C$3:$E$3,
IF($B$8=$F$4,$C$4:$E$4,
IF($B$8=$F$5,$C$5:$E$5)))

$B$8 is the choice made in the previous list. In the first list you select a client company from the list (a simple range defined in the drop down list). This next drop down list then presents 3 contact names for the corresponding company selected from the first list. This range of 3 changes depending on the company selected

It works but due to the limits on the number of if statements you can have (is it 64?) and also the time in writing them I wanted to try vlookup but was not sure how to apply it in the field of a drop down list range.

I have attached the example.

Using if statements to define multiple ranges in a drop down list.xlsx

Would love to hear from anyone who has any suggestions.
Thanks!