Use Vlookup-result as input for Dropdown-list

[ed_terpstra]

Hi all, looking for a sollution for a Vlookup output to drive the content of a dropdown list.

eg: B2 contains VLOOKUP function. How do i make that result become input for a variable dropdown in C2?

So, if Vlookup B2 = Belgium, then dropdown in C2 should show "Antwerp", "Liege", "Brussels"
but if Vlookup B2 = FRANCE, then dropdown should show "Paris", "Marseille", "Nancy"

thanks

 

[John Jairo V]

Hi @ed_terpstra

In this link you can see several options. Blessings!

http://chandoo.org/wp/tag/drop-down-lists/