Have a problem where if the fund isn't on the tab, it randomly returns a value. Is this formula the best? Can it be corrected or improved?
INDEX('Paste Summary'!$L:$L,MATCH(C$1,IF('Paste Summary'!$I:$I="Total NAV",'Paste Summary'!$C:$C,"")))
Where C1 = 1150
In the summary tab have column data headed by
Column C - Fund ie 1000, 1150, 1120 etc
Column I – Asset Description
Column L – Values
INDEX('Paste Summary'!$L:$L,MATCH(C$1,IF('Paste Summary'!$I:$I="Total NAV",'Paste Summary'!$C:$C,"")))
Where C1 = 1150
In the summary tab have column data headed by
Column C - Fund ie 1000, 1150, 1120 etc
Column I – Asset Description
Column L – Values