From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Two source drop-down

Two source drop-down - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Two source drop-down

“

- [Instructor] This one is exciting. When you get this one, you're going to really have some Excel prowess, and I want you to go outside after you get this, go outside and scream to the world, "I have conquered Excel" and say it loud. Okay, here's the data. We've got cities in two counties, Longwood County, Archer County. Over in B3, I have the city of Elysium, and I have retrieved the population. There is an XLOOKUP nested in an XLOOKUP, but I have to type this, and what if I do, okay, I want Ocean View. Oh! You're breaking my heart. No, Oceanview is one word. We need a dropdown list here in B3, but it's got to have the names of the cities in both counties in a single dropdown list, all right? And then, because this is going to be so exciting and feel so good, add some new cities. Make up some city names. Add 'em in either or both of the counties. Make up a population and then test to make sure that they show up…

Contents