Hi i need a formula that will return trust in Col b based on the info in Col E:G
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | Pfolio | Trust | Trust | Pfolio | Subpfolio | ||||
3 | eri061 | Property Trust | Property Trust | OPTMOD | |||||
4 | OPTMOD | Moderate | Moderate | eri061 | |||||
5 | CAETRN | Aus Equities | Aus Equities | CAETRN | |||||
Sheet1 |