Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
challange Please Help
If I may Please request Help with a big challenge: I have a drop down list of codes, the codes read 1/5's, 1/5 & 1, 1/5 & 2 and so on. I want to set this up so that when you pick from the drop down list a code it will fill in the cell next to it the value that the code referenced. Example: OK 1/5 = .95 so when you chose 1/5 from the list the next cell reads .95. I have all the values to reference. I just do not know to do this and write the code for it. Your help will be most appreciated. Thank you, Michael D Bay -- Michael D Bay ------------------------------------------------------------------------ Michael D Bay's Profile: http://www.excelforum.com/member.php...o&userid=31842 View this thread: http://www.excelforum.com/showthread...hreadid=516850 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
challange Please Help
If you have a list of the values then build a table of codes and values and
then use VLOOKUP =VLOOKUP(dv_value,lookup_table,2,False) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Michael D Bay" wrote in message news:Michael.D.Bay.23w4ta_1141048202.2794@excelfor um-nospam.com... If I may Please request Help with a big challenge: I have a drop down list of codes, the codes read 1/5's, 1/5 & 1, 1/5 & 2 and so on. I want to set this up so that when you pick from the drop down list a code it will fill in the cell next to it the value that the code referenced. Example: OK 1/5 = .95 so when you chose 1/5 from the list the next cell reads .95. I have all the values to reference. I just do not know to do this and write the code for it. Your help will be most appreciated. Thank you, Michael D Bay -- Michael D Bay ------------------------------------------------------------------------ Michael D Bay's Profile: http://www.excelforum.com/member.php...o&userid=31842 View this thread: http://www.excelforum.com/showthread...hreadid=516850 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting challange | Excel Worksheet Functions | |||
challange | Excel Discussion (Misc queries) | |||
Macro problem...Will be a real challange | Excel Programming | |||
I give up-- I need help Pleeeezze? Anybody up to a little challange? | Excel Programming | |||
a CHALLANGE using OR in an array formula | Excel Worksheet Functions |