return value from other spreadsheet
i have this formula
=IF(COUNTIF(Path/Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path/Income
securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path/Property &
Infrastructure'!$B$10:$B$413,A4),"PI","None")))
i want S, FI or PI to be returned depending on where the value in A4 is
found, but i get a value message.
Please help.
thank you
|