I want a formula that i will put on remarks column, I want it to show the name of the leader from column "Leader" depending on what team the name belong. I have a sample table below. On my example team orange has a leader James thats why on the column remarks James appear depending on the coresponding team name from column "Team". thanks
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Team | Leader | Remarks | ||
2 | Orange | James | James | ||
3 | orange | James | |||
4 | orange | James | |||
5 | Orange | James | |||
6 | Apple | Mimi | Mimi | ||
7 | Apple | Mimi | |||
8 | Apple | Mimi | |||
9 | Grapes | Larry | Larry | ||
10 | Grapes | Larry | |||
11 | Grapes | Larry | |||
12 | Grapes | Larry | |||
Sheet1 |