Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
This may be simple but I'm new...forgive me...
I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
How many variables are there? If it's more than 4-5 and there's no
sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
There may be as many at 10 numerical variables and they will just be
sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
Hi, Dave
This is completely off topic and has nothing to do with your post, but in case you're interested I've found the solution to the "No focus rectangles when using XP styles on VB6 project" problem you posted somewhere last year. Hit the same brick wall this morning and have finally figured out the answer. Cheers and good luck with the Excel post! Mark "Dave" wrote: This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
Ok, does that work like you want it to?
Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
to some extent although is it possible to have the numerical value returned
in the same cell as the drop down menu..??? Thanks for the help so far!!! Dave "T. Valko" wrote: Ok, does that work like you want it to? Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
is it possible to have the numerical value returned
in the same cell as the drop down menu..??? Not using worksheet formulas. It can probably be done with some VBA code but I don't know how to do it. Biff "Dave" wrote in message ... to some extent although is it possible to have the numerical value returned in the same cell as the drop down menu..??? Thanks for the help so far!!! Dave "T. Valko" wrote: Ok, does that work like you want it to? Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
Ok, thanks again for the help...I think we can still work it with what you've
given us....appreciate it... Dave "T. Valko" wrote: is it possible to have the numerical value returned in the same cell as the drop down menu..??? Not using worksheet formulas. It can probably be done with some VBA code but I don't know how to do it. Biff "Dave" wrote in message ... to some extent although is it possible to have the numerical value returned in the same cell as the drop down menu..??? Thanks for the help so far!!! Dave "T. Valko" wrote: Ok, does that work like you want it to? Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
You're welcome!
Biff "Dave" wrote in message ... Ok, thanks again for the help...I think we can still work it with what you've given us....appreciate it... Dave "T. Valko" wrote: is it possible to have the numerical value returned in the same cell as the drop down menu..??? Not using worksheet formulas. It can probably be done with some VBA code but I don't know how to do it. Biff "Dave" wrote in message ... to some extent although is it possible to have the numerical value returned in the same cell as the drop down menu..??? Thanks for the help so far!!! Dave "T. Valko" wrote: Ok, does that work like you want it to? Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
Sorry, if I could bug you one more time........when you cut and paste a
formula into a cluster of cells within a column (using the VLookup format) how do you keep the reference array the same.....everytime I cut and paste the reference cell numbers also change??? thx.. Dave "T. Valko" wrote: You're welcome! Biff "Dave" wrote in message ... Ok, thanks again for the help...I think we can still work it with what you've given us....appreciate it... Dave "T. Valko" wrote: is it possible to have the numerical value returned in the same cell as the drop down menu..??? Not using worksheet formulas. It can probably be done with some VBA code but I don't know how to do it. Biff "Dave" wrote in message ... to some extent although is it possible to have the numerical value returned in the same cell as the drop down menu..??? Thanks for the help so far!!! Dave "T. Valko" wrote: Ok, does that work like you want it to? Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
Make the references to the lookup table absolute:
=VLOOKUP(D1,$A$1:$B$3,2,0) Biff "Dave" wrote in message ... Sorry, if I could bug you one more time........when you cut and paste a formula into a cluster of cells within a column (using the VLookup format) how do you keep the reference array the same.....everytime I cut and paste the reference cell numbers also change??? thx.. Dave "T. Valko" wrote: You're welcome! Biff "Dave" wrote in message ... Ok, thanks again for the help...I think we can still work it with what you've given us....appreciate it... Dave "T. Valko" wrote: is it possible to have the numerical value returned in the same cell as the drop down menu..??? Not using worksheet formulas. It can probably be done with some VBA code but I don't know how to do it. Biff "Dave" wrote in message ... to some extent although is it possible to have the numerical value returned in the same cell as the drop down menu..??? Thanks for the help so far!!! Dave "T. Valko" wrote: Ok, does that work like you want it to? Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning numerical value to text
Once again...many thanks,
Dave "T. Valko" wrote: Make the references to the lookup table absolute: =VLOOKUP(D1,$A$1:$B$3,2,0) Biff "Dave" wrote in message ... Sorry, if I could bug you one more time........when you cut and paste a formula into a cluster of cells within a column (using the VLookup format) how do you keep the reference array the same.....everytime I cut and paste the reference cell numbers also change??? thx.. Dave "T. Valko" wrote: You're welcome! Biff "Dave" wrote in message ... Ok, thanks again for the help...I think we can still work it with what you've given us....appreciate it... Dave "T. Valko" wrote: is it possible to have the numerical value returned in the same cell as the drop down menu..??? Not using worksheet formulas. It can probably be done with some VBA code but I don't know how to do it. Biff "Dave" wrote in message ... to some extent although is it possible to have the numerical value returned in the same cell as the drop down menu..??? Thanks for the help so far!!! Dave "T. Valko" wrote: Ok, does that work like you want it to? Biff "Dave" wrote in message ... There may be as many at 10 numerical variables and they will just be sequential from 1 to 10. The drop down list may contain as many as 5 words. Just to start, as a test, I've created just three text entries in the drop down list and wish to assign them simply the numbers 1 to 3. I've created two reference columns one containing the text and the next containing the numbers 1 to three corresponding to the text.....The drop down menu's will extend the entire length of the column...in this case column B.... "T. Valko" wrote: How many variables are there? If it's more than 4-5 and there's no sequential pattern to the logic then your best bet is to create a lookup table. For example: ...........A..........B 1.......Red.......10 2.......Blue.......25 3.......Green....37 Your drop down list is in cell D1 and the selections are Red, Blue or Green. Then in say, cell E1 you'd use this formula: =VLOOKUP(D1,A1:B3,2,0) Biff "Dave" wrote in message ... This may be simple but I'm new...forgive me... I've created drop-down lists in a column with several variables all in text from a list. I am trying to make it so that when I click on a variable, the numerical value is displayed in the cell.... Any help would be appreciated.....maybe I'm looking in the wrong spot but I couldn't find it under all the "Help" topics.... Thanks, Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
assigning numbers to text entries | Excel Discussion (Misc queries) | |||
I want to check for a text value, not numerical | Excel Worksheet Functions | |||
Assign numerical values to text codes | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |