Hi

You can use IF formulae in A2:
=IF(A1="Test",16,IF(A1="Test2",20))

Hope this helps.
Andy.

"3Pinter" wrote in
message ...

Hi,

I have a list, using validation and created a dropdown cell.

Is it possible to create somesort of a check:
cell A1 is the dropdown. If cell A1 value = "test" cell A2 should be a
certain value (if possible a simple formula stated in another
worksheet). if cell A1 = value "test2" A2 should become another value /
formula.

Can this be done dynamicly?

thanks.

3Pinter


--
3Pinter
------------------------------------------------------------------------
3Pinter's Profile:
http://www.excelforum.com/member.php...o&userid=32623
View this thread: http://www.excelforum.com/showthread...hreadid=527957