Drop down Menu with simplified options

Copper Contributor

Hi

 

I am looking to create a drop down menu that gives people a choice of file paths, which as a result of the choice in the drop down menu will give a list of files in a certain folder. However the people using the spreadsheet only need a simplified list of options. Is it possible for me to create a drop down list that has just one key word for each file path that will then reference the full path in the formula below.

 

i.e make the drop down say    "certificates" 

but the value actually represented in the cell and then as a result inputted into the formula below is c:\training\employees\Barry Venison\certificates\*

 

Thanks

 

Dave

2 Replies