Good morning,
Apologies if this has already been asked multiple times, I am fairly new to using Excel formulas and I have tried to find the answer on here but can't find one that seems to match what I need.
I manage training for large groups of people in my business and this is done by uploading a spreadsheet of user info to our third party e-learning platform. Each user has to complete a specific introductory module based on their job role/job title. There are only 8 different modules but 200+ job titles so knowing which one to pick isn't always straightforward without having to look the information up.
What I need is a formula that returns the name of the module required based on the job title entered in a different cell, so e.g. if the job title entered can be found in THIS range of values, return module X, if found in THAT range of values, return module Y, etc...
Any help would be greatly appreciated.
Many thanks.
Bookmarks