Hi!
When I write the function bellow:
=IF('file:///E:/Cronoslot/DVP/SCP/MATCON_SCP_001.ods'#$material.C91<>"";INDEX('file:///E:/Cronoslot/DVP/SCP/MATCON_SCP_001.ods'#$material.$C$6:$C$125;MATCH(D91;'file:///E:/Cronoslot/DVP/SCP/MATCON_SCP_001.ods'#$material.$D$6:$D$125;0)))
I get the result expected when the external spreadsheet have the value.
But when the value does not exist I get an annoying #N/A and the
subsequent operations give the result #N/A, as expected. How can I
change the #N/A for a 0 (Zero) or a blank cell?
Thank you for your time a knowledge,
EVarejão
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
