Hello all

I have the following table in excel

Full Name HisSuper SuperId
DAVIES, ROBERT K 1 1
WILLIAMSON, BRUCE E 1 2
WOLFE, THOMAS B 1 3
CARLSON, JERRY 2 4
KEATING, JOHN P 9 5
SWARTZ, KURT 3 6
DENISON, LESTER 5 7
RICHARDS, KARYN B 1 8
JENSEN, JAMES K 1 9
FRANK, PETER J 8 10
DUNSTAN, FRANK 1
KASHDAN, LINDA R 1
REILLY, SUSAN 1
SHEEHAN, FRANCIS E 1
ANDRITZ, GERALD J 2
CRAWFORD, SLOANE N 2
GORKA, DEBRA A 2
KRAMARCHYK, MARY C 2
LEE, DAVID 2
SCHMID, DOUGLAS A 2
BERNHARD, DOUGLAS 3
FRASER, CAROLE A 3
PERHAM, DENNIS R 3
VANDREI, CHARLES E 3
DENHAM, JASON 4
DIAMOND, STEPHANIE J 6
VERSCHOOR, KARIN 6
EDDY, DARRYL G 7
HUGHES, DONALD R 7
MORRELL, ROBERT A 7
REYNOLDS, TIMOTHY A 9
MESSENGER, ROBERT 10


How can i get the values of Full name based on "hissuper" for example
supervisor for row 2 is 1=Davis Robert K,like wise i want for all the values.

Thank you for any help