Forum Discussion

cheeseontoast101's avatar
cheeseontoast101
Copper Contributor
Jul 10, 2022

How can I do a function around a workbook link?

Hi

 

I'd like to incorporate an if error into

 

='{testworkbook.xlsx]sheet1'!D7

 

how can I do this?

  • Charla74's avatar
    Charla74
    Iron Contributor
    You should be able to use the IFERROR function as normal as follows (where if true it simply returns the text 'Error'):

    =IFERROR('{testworkbook.xlsx]sheet1'!D7,"Error")

Resources