So, there
is a Logical formula in Column E. IFERROR Logical
formulas are binary. They only have two answers: Value if TRUE,
Value_If_Error.
This formula shows the data from Cell B2, the
Value if TRUE. What do you
see if there is a mistake? 4.
Try it: Make a Mistake Select
Cell C2. The HLOOKUP formula should be available in the Formula Bar. Edit the
Name: Change Terms to Term 5. What
Do You See? Changing the Named Range created an error in Cell
C2. By definition, #NAME? means that Excel cannot find that Name in
the Name Manager. What
Else Do You See? The IFERROR Formula in Cell E2 now shows the
Value_If_Error: No Data Available.
|
|
| |
