Copy cell value copies source range’s value as #NAME

Copy cell value copies source range’s value as #NAME in target worksheet, when source range contains IFERROR() formula.

Why does this happen?

This is known limitation of the function at the moment. However, please use the suggested workaround until issue has been addressed properly.

How to fix this

Instead of using formula as =IFERROR(A1,0), please use =IF(ISERROR(A1),”Has Error”,A1).

Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox