Hi All,
Good morning/afternoon/evening depending on where you are in the world.
I've run into a little problem on this fine Monday morning! I feel like its a really easy one and I'm just being an idiot, or the weekend hasn't quite worn off completely I'm not sure! I've tried looking online and on the forum however I feel like my wording in the searches hasn't been producing the right results.
Basically I have a list of patients and they've been seeing two types of doctors, psychologists and psychiatrists. I want to make it so when the doctors name is entered it automatically assigns their role in the next cell. I have all the doctors names in two lists based on their role and would like to use that list the check against the name entered on the patient list.
<tbody>
</tbody>
The "Doctor Role" column is the one I'd like the formula in and the text in brackets is how it should read off if it works! As I said I don't think its actually as complicated as I'm making it for myself but Monday is Monday! Hope someone can help!
Good morning/afternoon/evening depending on where you are in the world.
I've run into a little problem on this fine Monday morning! I feel like its a really easy one and I'm just being an idiot, or the weekend hasn't quite worn off completely I'm not sure! I've tried looking online and on the forum however I feel like my wording in the searches hasn't been producing the right results.
Basically I have a list of patients and they've been seeing two types of doctors, psychologists and psychiatrists. I want to make it so when the doctors name is entered it automatically assigns their role in the next cell. I have all the doctors names in two lists based on their role and would like to use that list the check against the name entered on the patient list.
Patient No. | Doctor Name | Doctor Role | Psychologist | Psychiatrist | |
1234 | Ollie Ollison | (Psychologist) | Ollie Ollison | Michael Michaelson | |
1235 | Phil Philson | (Psychiatrist) | David Davidson | Phil Philson | |
1236 | David Davidson | (Psychologist) | Laura Laurenson | ||
1237 | David Davidson | (Psychologist) | Steve Stevenson | ||
1238 | Laura Laurenson | (Psychologist) | |||
1239 | Michael Michaelson | (Psychiatrist) | |||
1240 | Phil Philson | (Psychiatrist) |
<tbody>
</tbody>
The "Doctor Role" column is the one I'd like the formula in and the text in brackets is how it should read off if it works! As I said I don't think its actually as complicated as I'm making it for myself but Monday is Monday! Hope someone can help!