Scrolldown that workes several ways

[Oeysbrei]

Hi,

I have attached a samplefile that explains specific what I want to achieve.
In general I want a scrolldown to show different values dependent on what is written in a sertain cell.

Thanks in advance!

Regards

Øystein

[José Augusto]

Hi

Try in B10 the following

Please Login or Register  to view this content.

and copy down

[mehmetcik]

Define a new named range.
EG MyList

use the formula

Please Login or Register  to view this content.

instead of the range in the setup.

When defining the data validation for B10 use "Select From List" and enter =Mylist

[Oeysbrei]

Hi,

Thanks for youre reply, but my version of excel is Norwegian, and I dont know how to convert these formulas. Is it possible for you to create this in the workbook for me to study.


Regards

Øystein

[mehmetcik]

Ok Try this workbook