iferror, match formula.

Hello All,

I need a formula that scans a list of a job titles and if a driving is part of their job function.

Please see attached spreadsheet:
Identified Driver.xlsb

'Training Matrix' Sheet is where the job titles (Line 2)as they relate to driving (Line 32).
'Data-EmployeeStatus' Sheet is where I have a list of employees and their given job titles (Column G) and if they are active (Column E)

I would like a formula on (Column H) that would give me these results:

1) If (Column E) is "Active" and (Column G) matches 'Training Matrix' (Line 2) is "R" along 'Training Matrix' (Line 32) then the result in cell is "Identified Driver"
2) If (Column E) is "Active" and (Column G) matches 'Training Matrix' (Line 2) is BLANK along 'Training Matrix' (Line 32) then the result in cell is BLANK
3) If (Column E) is "Active" and (Column G) Does Not match anything on 'Training Matrix' (Line 2) is "Job Title Error"
4) If (Column E) is "Departed" to ignore calculating and is BLANK

Thank you in advance.. I greatly appreciate the help!!!

Originally Posted by daffodil11

h2:

=IFERROR(IF(E2="Active",IF(INDEX('Training Matrix'!$N$32:$MH$32,MATCH(G2,'Training Matrix'!$N$2:$MH$2,0))="R","Identified Driver",""),""),"Job Title Error")

AND COPY DOWN

PERFECT! Works great, thanks!