intheblack
New Member
- Joined
- Sep 24, 2009
- Messages
- 9
Hi.
Wondering if someone could help with this. Sheet one below is the reference sheet. the following Data sheet is information pasted in. I am trying to get the names in Col a on the data sheet to match with the names in sheet one. Then, when matched they should return the 2 letter code in col c in col m on the data sheet.
I have a vlookup up formula there (in col m) (=VLOOKUP(A3,'Fund reporting catergories'!A:C,3,1) but it's not returning the correct codes? Am i missing something?
[TABLE="width: 509"]
<tbody>[TR]
[TD]AMP Capital Enhanced Yield Fund - Cl A(AMP0685AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]AMP Cap Global Prop Securit Fd -Class A(AMP0974AU)[/TD]
[TD][/TD]
[TD]RS[/TD]
[/TR]
[TR]
[TD]Future Directions International Share WS(AMP0683AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]AMP Capital International Bond Fd - WS(AMP0268AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]AMP Capital Listed Property Trusts Fd WS(AMP0269AU)[/TD]
[TD][/TD]
[TD]RS[/TD]
[/TR]
[TR]
[TD]AMP Capital WS Global Equity - Value(NML0348AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BlackRock Indexed Australian Bond Fund(BGL0105AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]BlackRock Indexed Australian Equity Fund(BGL0034AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]BlackRock Scientific Hdg Int'l Eqty Fd(BGL0109AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BlackRock Indexed International Eqty Fd(BGL0106AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BlackRock Scientific Australian Eqty Fd(BAR0814AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]Hyperion Small Growth Companies Fund(BNT0101AU)[/TD]
[TD][/TD]
[TD]AS[/TD]
[/TR]
[TR]
[TD]BT WS Balanced Returns Fund(BTA0806AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]BT WS Asian Share Fund(BTA0054AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BT WS Australian Share Fund(BTA0055AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]Colonial First State WS Global Resources(FSF0038AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]Colonial First State WS Income Fund(FSF0139AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]Challenger Guaranteed Income Fund(HOW0087AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]Cash Holding Account[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Aberdeen Multi-Asset Income Fund(CRS0001AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]Bentham Wholesale Global Income Fund(CSA0038AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 832"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Cash Holding Account[/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]28,863.89[/TD]
[TD="class: xl67, width: 64"]3[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 704, colspan: 11"]Managed Investments[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]AMP Capital Enhanced Yield Fund - Cl A (AMP0685AU) ^[/TD]
[TD="class: xl66"]-[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]5,093.28[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Bentham Wholesale Global Income Fund (CSA0038AU)[/TD]
[TD="class: xl66"]8.2[/TD]
[TD="class: xl67, width: 64"]12[/TD]
[TD="class: xl67, width: 64"]15[/TD]
[TD="class: xl67, width: 64"]75[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]-2[/TD]
[TD="class: xl68, width: 64"]90,516.87[/TD]
[TD="class: xl67, width: 64"]8[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]BlackRock Indexed Australian Equity Fund (BGL0034AU)[/TD]
[TD="class: xl66"]7.2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl66"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]82,754.44[/TD]
[TD="class: xl67, width: 64"]7[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]BlackRock Indexed International Eqty Fd (BGL0106AU)[/TD]
[TD="class: xl66"]7.2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]82,899.23[/TD]
[TD="class: xl67, width: 64"]7[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Colonial First State WS Income Fund (FSF0139AU) ^[/TD]
[TD="class: xl66"]-[/TD]
[TD="class: xl67, width: 64"]4[/TD]
[TD="class: xl67, width: 64"]96[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]227.92[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Australian Value Trust (DFA0101AU)[/TD]
[TD="class: xl66"]5.4[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]61,996.55[/TD]
[TD="class: xl67, width: 64"]5[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Five-year Div Fixed Int Tr (DFA0108AU)[/TD]
[TD="class: xl66"]11[/TD]
[TD="class: xl67, width: 64"]4[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]96[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Global Small Company Trust (DFA0106AU)[/TD]
[TD="class: xl66"]5.4[/TD]
[TD="class: xl67, width: 64"]1[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]99[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]63,229.78[/TD]
[TD="class: xl67, width: 64"]6[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Global Value Trust (DFA0102AU)[/TD]
[TD="class: xl66"]5.4[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]62,116.26[/TD]
[TD="class: xl67, width: 64"]5[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Hyperion Small Growth Companies Fund (BNT0101AU)[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="class: xl67, width: 64"]5[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]95[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]32,023.29[/TD]
[TD="class: xl67, width: 64"]3[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ironbark Karara Aus Small Companies (PAT0002AU)[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="class: xl67, width: 64"]6[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]94[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]32,448.48[/TD]
[TD="class: xl67, width: 64"]3[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Lazard Emerging Markets Eqty - I Class (LAZ0003AU)[/TD]
[TD="class: xl66"]4.5[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]46,770.38[/TD]
[TD="class: xl67, width: 64"]4[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Money Market Investment Account[/TD]
[TD="class: xl66"]13.8[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]EM[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]PIMCO EQT Wholesale Div Fixed Interest (ETL0016AU)[/TD]
[TD="class: xl66"]11[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]51[/TD]
[TD="class: xl67, width: 64"]49[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]RS[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]UBS Clarion Global Property Securities (HML0016AU)[/TD]
[TD="class: xl66"]2.25[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]26,577.41[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Vanguard Aust Fixed Interest Index Fund (VAN0001AU)[/TD]
[TD="class: xl66"]11[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Vanguard Property Securities Index Fund (VAN0004AU)[/TD]
[TD="class: xl66"]2.25[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]26,227.23[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
Thanks
Wondering if someone could help with this. Sheet one below is the reference sheet. the following Data sheet is information pasted in. I am trying to get the names in Col a on the data sheet to match with the names in sheet one. Then, when matched they should return the 2 letter code in col c in col m on the data sheet.
I have a vlookup up formula there (in col m) (=VLOOKUP(A3,'Fund reporting catergories'!A:C,3,1) but it's not returning the correct codes? Am i missing something?
[TABLE="width: 509"]
<tbody>[TR]
[TD]AMP Capital Enhanced Yield Fund - Cl A(AMP0685AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]AMP Cap Global Prop Securit Fd -Class A(AMP0974AU)[/TD]
[TD][/TD]
[TD]RS[/TD]
[/TR]
[TR]
[TD]Future Directions International Share WS(AMP0683AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]AMP Capital International Bond Fd - WS(AMP0268AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]AMP Capital Listed Property Trusts Fd WS(AMP0269AU)[/TD]
[TD][/TD]
[TD]RS[/TD]
[/TR]
[TR]
[TD]AMP Capital WS Global Equity - Value(NML0348AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BlackRock Indexed Australian Bond Fund(BGL0105AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]BlackRock Indexed Australian Equity Fund(BGL0034AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]BlackRock Scientific Hdg Int'l Eqty Fd(BGL0109AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BlackRock Indexed International Eqty Fd(BGL0106AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BlackRock Scientific Australian Eqty Fd(BAR0814AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]Hyperion Small Growth Companies Fund(BNT0101AU)[/TD]
[TD][/TD]
[TD]AS[/TD]
[/TR]
[TR]
[TD]BT WS Balanced Returns Fund(BTA0806AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]BT WS Asian Share Fund(BTA0054AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]BT WS Australian Share Fund(BTA0055AU)[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD]Colonial First State WS Global Resources(FSF0038AU)[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]Colonial First State WS Income Fund(FSF0139AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]Challenger Guaranteed Income Fund(HOW0087AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]Cash Holding Account[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Aberdeen Multi-Asset Income Fund(CRS0001AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD]Bentham Wholesale Global Income Fund(CSA0038AU)[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 832"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Cash Holding Account[/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]28,863.89[/TD]
[TD="class: xl67, width: 64"]3[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 704, colspan: 11"]Managed Investments[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]AMP Capital Enhanced Yield Fund - Cl A (AMP0685AU) ^[/TD]
[TD="class: xl66"]-[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]5,093.28[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Bentham Wholesale Global Income Fund (CSA0038AU)[/TD]
[TD="class: xl66"]8.2[/TD]
[TD="class: xl67, width: 64"]12[/TD]
[TD="class: xl67, width: 64"]15[/TD]
[TD="class: xl67, width: 64"]75[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]-2[/TD]
[TD="class: xl68, width: 64"]90,516.87[/TD]
[TD="class: xl67, width: 64"]8[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]BlackRock Indexed Australian Equity Fund (BGL0034AU)[/TD]
[TD="class: xl66"]7.2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl66"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]82,754.44[/TD]
[TD="class: xl67, width: 64"]7[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]BlackRock Indexed International Eqty Fd (BGL0106AU)[/TD]
[TD="class: xl66"]7.2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]82,899.23[/TD]
[TD="class: xl67, width: 64"]7[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Colonial First State WS Income Fund (FSF0139AU) ^[/TD]
[TD="class: xl66"]-[/TD]
[TD="class: xl67, width: 64"]4[/TD]
[TD="class: xl67, width: 64"]96[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]227.92[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Australian Value Trust (DFA0101AU)[/TD]
[TD="class: xl66"]5.4[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]61,996.55[/TD]
[TD="class: xl67, width: 64"]5[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Five-year Div Fixed Int Tr (DFA0108AU)[/TD]
[TD="class: xl66"]11[/TD]
[TD="class: xl67, width: 64"]4[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]96[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Global Small Company Trust (DFA0106AU)[/TD]
[TD="class: xl66"]5.4[/TD]
[TD="class: xl67, width: 64"]1[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]99[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]63,229.78[/TD]
[TD="class: xl67, width: 64"]6[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Dimensional Global Value Trust (DFA0102AU)[/TD]
[TD="class: xl66"]5.4[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]62,116.26[/TD]
[TD="class: xl67, width: 64"]5[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Hyperion Small Growth Companies Fund (BNT0101AU)[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="class: xl67, width: 64"]5[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]95[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]32,023.29[/TD]
[TD="class: xl67, width: 64"]3[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Ironbark Karara Aus Small Companies (PAT0002AU)[/TD]
[TD="class: xl66"]2.7[/TD]
[TD="class: xl67, width: 64"]6[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]94[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]32,448.48[/TD]
[TD="class: xl67, width: 64"]3[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Lazard Emerging Markets Eqty - I Class (LAZ0003AU)[/TD]
[TD="class: xl66"]4.5[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]46,770.38[/TD]
[TD="class: xl67, width: 64"]4[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Money Market Investment Account[/TD]
[TD="class: xl66"]13.8[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]EM[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]PIMCO EQT Wholesale Div Fixed Interest (ETL0016AU)[/TD]
[TD="class: xl66"]11[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]51[/TD]
[TD="class: xl67, width: 64"]49[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]RS[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]UBS Clarion Global Property Securities (HML0016AU)[/TD]
[TD="class: xl66"]2.25[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]26,577.41[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD][/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Vanguard Aust Fixed Interest Index Fund (VAN0001AU)[/TD]
[TD="class: xl66"]11[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64, align: center"]########[/TD]
[TD="class: xl67, width: 64"]11[/TD]
[TD][/TD]
[TD]FI[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64"]Vanguard Property Securities Index Fund (VAN0004AU)[/TD]
[TD="class: xl66"]2.25[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[TD="class: xl67, width: 64"]0[/TD]
[TD="class: xl68, width: 64"]26,227.23[/TD]
[TD="class: xl67, width: 64"]2[/TD]
[TD][/TD]
[TD]AL[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
Thanks