'Check importrange for errors ref

Two tables are created, The first table handles IMPORTXML data The second table gets data from the first table through IMPORTRANGE

When I get load, I randomly get an error in table 2 #REF! Question: How do I check for #REF! errors?

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source