I've got a sheet where if a particular value is chosen from drop down list some cells are filled with vlookup value. Despite filling in some cells with the formula I would like it to change the action of existing button.
The button is supposed to open a file, and different file should be opened based on the drop down list value (the file that is being used in the vlookup formula).
Is it possible in excel with a button or another solution is necessary?
Bookmarks