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?
- Charla74Iron ContributorYou 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")