that_one_girl
New Member
- Joined
- Mar 22, 2017
- Messages
- 43
Hi again -
So I am trying to compare lists.
I have 3 workbooks that I am using.
#1 - Has Mandated Classes with staff names
#2 - Has training records for all staff (current and retired)
#3 - Is a master reference workbook
What I'm trying to do is
In #1 - create a formula that will look for staff name in A7 and ID# and find it in workbook #2
If that name is found, then find a class listed in #2 from a list of classes in #3
If #2 has an employees name, and a class next to it from the list in #3 , then in #1 show the name of the class that was taken. I only need one of the course names. It doesn't matter which. Just one of them.
EXAMPLE:
#1 - Mandated Classes
<tbody>
</tbody>ACEE, J O6260 ENF <blank> <-------------I need this to show "Electrical Safety" or stay blank if there is no match.
#2 - Training Records ("ALL RECORDS" tab)
<tbody>
</tbody>Electrical Safety 8 ACCE, J O6260
#3 - Master Reference Book ("MAND. TBL REFERENCES" tab)
<tbody>
</tbody>
This is the formula I have. Obviously.........it's not working. Any help? Pretty please.......
=IF(COUNTIFS('DOSHTrainingRecordsVer.03-AL.xlsm'!SUBJECT,'[MasterRefSheets.xlsm]MAND. TBL REFERENCES'!$A$2:$A$42,'DOSHTrainingRecordsVer.03-AL.xlsm'!CSHO_NAME,$A7,'DOSHTrainingRecordsVer.03-AL.xlsm'!CSHO_ID,$B7),CELL"contents","")</blank>
So I am trying to compare lists.
I have 3 workbooks that I am using.
#1 - Has Mandated Classes with staff names
#2 - Has training records for all staff (current and retired)
#3 - Is a master reference workbook
What I'm trying to do is
In #1 - create a formula that will look for staff name in A7 and ID# and find it in workbook #2
If that name is found, then find a class listed in #2 from a list of classes in #3
If #2 has an employees name, and a class next to it from the list in #3 , then in #1 show the name of the class that was taken. I only need one of the course names. It doesn't matter which. Just one of them.
EXAMPLE:
#1 - Mandated Classes
NAME (A) | CSHO/EE ID (B) | UNIT (C) | CLASS (D) |
<tbody>
</tbody>
#2 - Training Records ("ALL RECORDS" tab)
CLASS (C) | HRS (D) | NAME (E) | CSHO ID (F) |
<tbody>
</tbody>
#3 - Master Reference Book ("MAND. TBL REFERENCES" tab)
TECHNICAL CLASS 1 (A) | ||||
Agricultural Safety and Health | ||||
Applied Welding Principles | ||||
Certified Safety Professional Exam Preparation | ||||
Combustible Dust | ||||
Concrete Forms and Shoring | ||||
Construction Safety | ||||
Cranes and Rigging | ||||
<tbody> </tbody> |
<tbody>
</tbody>
This is the formula I have. Obviously.........it's not working. Any help? Pretty please.......
=IF(COUNTIFS('DOSHTrainingRecordsVer.03-AL.xlsm'!SUBJECT,'[MasterRefSheets.xlsm]MAND. TBL REFERENCES'!$A$2:$A$42,'DOSHTrainingRecordsVer.03-AL.xlsm'!CSHO_NAME,$A7,'DOSHTrainingRecordsVer.03-AL.xlsm'!CSHO_ID,$B7),CELL"contents","")</blank>