MEUserII
Board Regular
- Joined
- Oct 27, 2017
- Messages
- 91
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- Windows
Consider the following table.
<tbody>
</tbody>
If the range is taken from: $A$1:$A$5, and that range is represented as an array in B1 using the formula entered: =$A$1:$A$5; which is equal to the array: {1; 2; #VALUE!; 4 ;5} (when pressing F9 to view full cell contents); then is there a way to substitute the "#VALUE!" element in this array?
In other words, substitute the "#VALUE!" from {1; 2; #VALUE!; 4; 5} to {1; 2; X; 4; 5}; where "X" represents what is substituted for the "#VALUE!" error?
For reference, this question builds on the useful information provided in this thread: https://www.mrexcel.com/forum/excel-questions/1084361-if-value-then-action.html
A | B | C | |
1 | 1 | =$A$1:$A$5 | |
2 | 2 | ||
3 | =VALUE("THREE") | ||
4 | 4 | ||
5 | 5 |
<tbody>
</tbody>
If the range is taken from: $A$1:$A$5, and that range is represented as an array in B1 using the formula entered: =$A$1:$A$5; which is equal to the array: {1; 2; #VALUE!; 4 ;5} (when pressing F9 to view full cell contents); then is there a way to substitute the "#VALUE!" element in this array?
In other words, substitute the "#VALUE!" from {1; 2; #VALUE!; 4; 5} to {1; 2; X; 4; 5}; where "X" represents what is substituted for the "#VALUE!" error?
For reference, this question builds on the useful information provided in this thread: https://www.mrexcel.com/forum/excel-questions/1084361-if-value-then-action.html
Last edited: