M
Mig
Hi experts
I like to have a tabel like this
This is one 1
This is two 2
This is someother 5
Text 4
that say a text that is assosiated with a number. Then (some where else in
the spreedsheet) I like to have a drop down wther I can choose between
("This is one"; "This is two", "This is..."), and depending on the choosen
text I will use the assosiated number in some calculations. Is this possible
with Excel?
e.g. if in the drop down is in cell A5, and there is choosen "This is Two",
and in cell A4 says 55 like to write some thing like this, in cell A6:
"=A5*A4" and the the result should be 110
Is this possible with Excel?
best regards
Torben
I like to have a tabel like this
This is one 1
This is two 2
This is someother 5
Text 4
that say a text that is assosiated with a number. Then (some where else in
the spreedsheet) I like to have a drop down wther I can choose between
("This is one"; "This is two", "This is..."), and depending on the choosen
text I will use the assosiated number in some calculations. Is this possible
with Excel?
e.g. if in the drop down is in cell A5, and there is choosen "This is Two",
and in cell A4 says 55 like to write some thing like this, in cell A6:
"=A5*A4" and the the result should be 110
Is this possible with Excel?
best regards
Torben