I work at a non-profit booking trips for people overseas. I work with 2 separate countries and am trying to simplify the process of budgeting the trips. There are only so many places we visit, but we have a few transportation options and lodging options depending on the country.
I have a spreadsheet that I've made where you would select the country in column B, then using the INDIRECT function as described on this page (http://www.contextures.com/xlDataVal02.html) I've created a drop down list in column C for places we visit. Now, in Column E I want to have another drop down list to choose where the group will stay based on the country choice in column B (I will also have yet another column for transportation options with a drop down list). I cannot seem to use the INDIRECT function as the named lists are used for column C. I thought that maybe a nested IF function would work, but I can only get it to accept that if I have only 1 choice in the drop down. Once I have multiple choices in the drop down list I get the error that the list source must be delimited or a reference to a single row or column. So...any help on creating more drop down lists based on the country selection would be great and I hope that all made sense. Thanks in advance for the help!