Creating a dynamic drop down list

On one sheet I have 4600 lines of data containing from left to right country, city, service, details and cost. On the other sheet I have a budget set up by service catagories. While I know changing the format of my budget could easily solve what I am about to ask I am powerless to do so, as it is above my head. My hope was to creat a drop down list on the budget where you select the specific detail and then use a v look up to have the corresponding cost pop up. On sheet 1 I was hoping that I could filter the data by country, city and service to find a more condensed list of the details I want and then have my drop down list with the details adapt to my filtering. Is there any way to do this? I thought using OFFSET and COUNTA in the list would work but it did not. Thanks 

By: James

Leave a Reply

Your email address will not be published. Required fields are marked *