Hi,
I am looking for VBA code to help with the following issue.
I have a cell where I can choose, from a dropdown menu, one or multiple choices.
The results, if I choose more than one value, are separated by a ",".
I would like some code to allow me, once I have made the choices from the dropdown menu, to perform a VLOOKUP function on the resulting words and put the results in another cell, separated by a "|".
Eg:
Cell I3 - if I choose just "intubation", I want Cell J3 to show "4362" (from a simple table where each word has just one corresponding number).
If Cell I3 is chosen to be "intubation, tracheostomy", I want Cell J3 to show "4362|4365" and so on.
any help appreciated!
C
I am looking for VBA code to help with the following issue.
I have a cell where I can choose, from a dropdown menu, one or multiple choices.
The results, if I choose more than one value, are separated by a ",".
I would like some code to allow me, once I have made the choices from the dropdown menu, to perform a VLOOKUP function on the resulting words and put the results in another cell, separated by a "|".
Eg:
Cell I3 - if I choose just "intubation", I want Cell J3 to show "4362" (from a simple table where each word has just one corresponding number).
If Cell I3 is chosen to be "intubation, tracheostomy", I want Cell J3 to show "4362|4365" and so on.
any help appreciated!
C
