I can't remember how to...

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.

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

Thanks. I've never been very comfortable with the VLookup thing. Can you provide a little help with that?
I put the numbers in H1:H23 and the corresponding words in I1:I23.
Thanks.

That did it. I appreciate the help.
Keep up the good work.

Thanks for the feedback.

Mangesh