I have a staffing program generating data in the following format. using 3
criteria shift, position (ie B61), secondary position (ie BC or Officer).
this list will be approx 300 records long. I have a second spreadsheet that
lists each position and needs to reach into this sheet and find the name of
the person that matches each of the 3 criteria. and i need help making the
formula.
Person Item (one column)
GARDEN, WAYNE J. A Shift - B61 - BC
BANKS, BARON W. A Shift - B66 - BC
MCADAMS, JIM A Shift - B71 - BC
SANTOS, MATTHEW D. A Shift - E61 - Engine Driver
FUHRMANN, NORBERT E. A Shift - E61 - Officer
NIELSON, JENNETT S. A Shift - L61 - Ladder Driver

here is an example of the second spreadsheet A-SHIFT B-SHIFT C-SHIFT
Engine 60
Officer name name name
Driver name name name
3rd name name name
4th name name name
Medic 60
PM name name name
RD name name name
Battalion 61
Batt. Chief name name name
Engine 61
Officer name name name
Driver name name name
3rd name name name
4th name name name