Hello Here is a Challange:
I have a drop down list in a cell 252 entries, when you make a choice
the choice will be like this (read like this) 1/5. Ok, so now I want
the cell next to the drop down list to covert or reference a value in
the form of a multiper. decimal point. So in this case when you choose
1/5 from the drop down list the cell next to this will read .95. That
is because 1/5 equals that. So the second example will be next choice
in the drop down list 1/5 & 1 the cell next to this will now be the
decimal of this, that is .9405. How can I make this happen.

Thanks let me know...


--
Michael D Bay
------------------------------------------------------------------------
Michael D Bay's Profile: http://www.excelforum.com/member.php...o&userid=31842
View this thread: http://www.excelforum.com/showthread...hreadid=515636