Sally, you could make it a bit easier by using OR instead of all those ELSEIFs. Like this:
IF [Manager]='Ramesh Razdan' OR
[Manager 1]='Ramesh Razdan' OR
[Manager 2]='Ramesh Razdan' OR
[Manager 3]='Ramesh Razdan' OR
[Manager 4]='Ramesh Razdan' THEN 'Big Data'
So essentially if Ramesh gets reassigned to any of those Manager roles, then Big Data will follow him. If that doesn't work for you then mock up a bit of data and post a packaged workbook.
I haven't tried your suggestion yet, but did post the workbook. I am confusing myself with the order of things as they flow down. I can add an individual towards the bottom, yet it doesn't seem to 'take'.
KM_Test.twbx 420.4 KB