'Alternative value of an indirect function
So in this case we have an INDEX statement:
=INDEX(INDIRECT("'"&AssemblingSheet!D$14&"'!"&"$A$1:$Q$53");11;3)
which returns for some columns blank values if there are obviously no values. If there is a blank it would be tremendous to copy the value of the column right next to it. So probably some kind of OR statement or something like that in-between:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|