| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cannot remember... | Excel Discussion (Misc queries) | |||
| Can someone please help me to remember | New Users to Excel | |||
| Can't remember....please assist | Excel Discussion (Misc queries) | |||
| I used to be able to do this, I can't remember how | Excel Discussion (Misc queries) | |||
| Remember and add | New Users to Excel | |||
![ForSale[_56_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
