Hi, I'll try to explain the sheet setup ...
Column F has one of two entries
PROJECT
SCHOOL
Column AB can contain a department code or be blank
MID
CNC
DEA
EDU
PGR
CCT
INT
RIP
(the list of codes goes on)
In column AJ I want a formula that says if column F=school and column AB=INT or MID or EDU...