I'm drawing a blank here. I have two columns in Excel, B5:C50. In B
there is a validation drop box with a series of numbers. When the user
selects one of the numbers, i want C to display a specific word. For
instance, if the user goes to B5 and selects the number 2, C5 should
display "example".
I just can't remember how to do this. Any suggestions?
Thanks.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=378851