Revelation343
New Member
- Joined
- Aug 18, 2015
- Messages
- 4
Table 1: (Data)
<tbody>
</tbody>
Table 2: Requirements
<tbody>
</tbody>
Excel version: 2013 (Windows)
Background: I am looking for a quick way to make sure the criteria of my role-play group is met through Excel. I'm not exactly sure how to combine the necessary lookup/array/nested if functions to make it happen. I haven't done anything moderately challenging in Excel since 2007 and my brain is at a loss on this one.
Results I am Looking For: I want Table 1, Column 6 to use an excel formula to: Lookup the Rank of the user, then verify that all criteria has been met. If it has not been met, then I would like it to tell me which criteria has not been met. I would be content with it just saying "NO" but if it could say "Trainings not met" or "Presentations not met" or "Total Points not met" or if there is a function advanced enough to identify that two or more have not been met then "Trainings not met" AND/OR "Presentations not met" AND/OR "Total Points not met". If the criteria is met, then a simple "Yes" is all I need there.
This seems like a lot to me, I remember it being possible, I just don't remember how I did it before and I don't know that I had this many criteria to meet the last time I did it.
User | Rank | Trainings | Presentations | Total | Requirements Met? |
Rob | Instuctor | 0 | 3 | 3 | |
Bill | Teacher | 12 | 15 | 27 |
<tbody>
</tbody>
Table 2: Requirements
Rank | Trainings | Presentations | Total Points |
Instructor | 6 | 6 | 30 |
Teacher | 7 | 7 | 30 |
Student Teacher | 8 | 6 | 30 |
Student Presenter | 8 | 6 | 30 |
Student Aide | 8 | 5 | 25 |
Intern | 8 | 5 | 20 |
Student | 8 | 3 | 15 |
Basic | 4 | 2 | 10 |
<tbody>
</tbody>
Excel version: 2013 (Windows)
Background: I am looking for a quick way to make sure the criteria of my role-play group is met through Excel. I'm not exactly sure how to combine the necessary lookup/array/nested if functions to make it happen. I haven't done anything moderately challenging in Excel since 2007 and my brain is at a loss on this one.
Results I am Looking For: I want Table 1, Column 6 to use an excel formula to: Lookup the Rank of the user, then verify that all criteria has been met. If it has not been met, then I would like it to tell me which criteria has not been met. I would be content with it just saying "NO" but if it could say "Trainings not met" or "Presentations not met" or "Total Points not met" or if there is a function advanced enough to identify that two or more have not been met then "Trainings not met" AND/OR "Presentations not met" AND/OR "Total Points not met". If the criteria is met, then a simple "Yes" is all I need there.
This seems like a lot to me, I remember it being possible, I just don't remember how I did it before and I don't know that I had this many criteria to meet the last time I did it.