Not sure if this is the best place for help. I haven’t done anything in calc/excel in years
What I’m trying to do is a little complex (for me atleast)
I have a drop down of words, I need each of the words to hold a value such as 1,5,10 etc. Then once that word is selected it needs to multiply by another value and divide by a third giving the sum needed. I have the last part down all separately but I can’t work out how to assign a value to a word?
Does this make sense ?
Thanks for any help
How should I know as long as I haven’t a clue to what you actually want to accomplish. Is there a real-world-task to solve?
Taking the question as an intelectual puzzle:
You can associate numeric values to (unique) words in different ways. A standard way is a lookup table, and there is the standard function VLOOKUP()supporting the method.
Talking of a “drop down of words” you may see different needs, but you should tell more clearly what that means for you: A validation list? (Where come the values from?) A ListBox? What else?
===Editing===
Missed to mention: A ListBox (FormControil object) Is the only way I know to get a “drop-down” directly returning the index (position in the list 1-based) of the selected word, and this way making the subsequent LOOKUP() obsolete. You can simply use that index to get the associated value from the table. An advantage of this variant is that the table of values doesn’t need to be placed next to the table of key-words. (A ComboBox doesn’t support this.)
Hello
Sorry I should have been more clear. As I said it’s been years since I’ve had to do anything like this
What I’m trying to do is create a proof of concept so I’m more just doing a test run
It’s for a medication calculator
So what Will happen is the weight of the patient would be inputted and then a drop down of drugs would be available to select. Each drug needs to have a set concentration to its name e.g. Paracetamol=10
I will then have a dose section where you can input your required dose e.g. 4(mg). Then the last box will be the amount and it will need given and the calculation will need to be
Weight* dose/concentration
I can do the calculation it’s just the adding the numerical Value to the selected drug
As I said I use to do this on excel about 10 years ago but moved industries so all my knowledge is completely gone or out of date
Thank you for any help
The example treats exclusively the assignment of a numeric value to a keyword without going into the further calculations.
(Ther is confusion concerning the used terms.)
ask91003assignValueToKeyword.ods (24.0 KB)