I am working on a project where I'm looking at four cities and collecting data on 10 different traits within each city's area codes. On the attached doc, I'm trying to build a tool in Sheet 1 where I can select the city from a dropdown list (which I've done), select the accompanying area code in that city I'm interested in (which I've done), and then have Excel auto populate the traits associated with that city and area code. I know I need to use vlookup but am having trouble figuring out how to do so. Would appreciate any help!
Bookmarks