Function With Lookup
Thank all of you, this work perfect.
OssieMac escreveu:
Hi again Dias,
Discard my previous formula and use this one. In the previous formula if the
sheet name is incorrect then it will still display an error. This one
accounts for blank or incorrect sheet name.
=IF(ISERROR(INDIRECT("'"&B1&"'!A1")),"",INDIRECT(" '"&B1&"'!A1"))
|