Forum Discussion
cheeseontoast101
Jul 10, 2022Copper Contributor
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
Jul 10, 2022Iron 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")
=IFERROR('{testworkbook.xlsx]sheet1'!D7,"Error")