In some empty region of your worksheet, create a list of numbers
and their corresponding words. Then, use the VLOOKUP function to
retrieve the word based on its number.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ForSale"
wrote in message
...

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