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.


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

I can't remember how to...
 

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

I can't remember how to...
 

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.


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

I can't remember how to...
 

Your master table is lets say in range A1:B5, which hold data like:
1 mangesh
2 example
3 forsale
4 four
5 five

In Cell I1, enter
=VLOOKUP(H1,$A$1:$B$5,2)

and copy down.

Mangesh


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

I can't remember how to...
 

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


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

I can't remember how to...
 

Thanks for the feedback.

Mangesh


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