Hi all,
I created a input sheet, where a choose a product from a list. (The product
list sheet). In an other sheet I have per product the releases. (the release
sheet)
The default value of the product release is found via a vlookup in the
release sheet.
Because of it might occur that I want to select a different release number
then the default release number, at this moment the formula for setting the
default can be overwritten with the input of a release number.
I want to make this input a dropdown menu, from the list of releases per
product.
So it depends on the selected product, and it has already a default value.
Without the default value , I can create the dropdown menu with the command
offset. But how to do this with a default value?

Regards,
Gerard