Jan 18 2023 08:21 AM
I have an excel sheet with 2 tabs to look up training for a date a course was completed.
First Tab has the information that needs to be displayed. That has a Table called "OxyTraining".
Second Tab has the lookup information in a table called "EmpTraining". I have a filed that combines the CourseID and EmployeeID to create a unique ID to lookup with.
In the OxyTraining table i have one course that could get credit if an employee completed 1 of 8 options. i am trying just to lookup 2 of the courses to see if i can get the formula to work. It pulls up if the 1st course is found but not the second, the value it shows it #N/A.
Here is the formulas i am trying:
=IF([@1075]=VLOOKUP([@1075],EmpTraining,1,FALSE),VLOOKUP([@1075],EmpTraining,7,FALSE),IF([@616]=VLOOKUP([@616],EmpTraining,1,FALSE),VLOOKUP([@616],EmpTraining,7,FALSE),""))
With this is someone has the 1075 course then it will show the Date but is someone has 616 the it shows #N/A.
Jan 18 2023 08:47 AM - edited Jan 18 2023 09:31 AM
*Edit - formula updated
=IF(ISNUMBER(MATCH([@1075],EmpTraining[Course ID & Emp ID],0)),VLOOKUP([@1075],EmpTraining,7,0),IF(ISNUMBER(MATCH([@616],EmpTraining[Course ID & Emp ID],0)),VLOOKUP([@616],EmpTraining,7,0),""))
Jan 18 2023 09:01 AM
Jan 18 2023 09:09 AM
Jan 18 2023 09:44 AM