Is it possible to use Index/Match to create an Org Hierarchy? For simplicity sake I've put in a few columns.
So since the manager is Steve in B2, C2 would populate with Steve's manager (Marcia). A result of that D4 would populate with Marcia's manager (Andrew).
A1: Employee Name (John)
B2...