Summary
Convert any text or number in reference with using INDIRECT formula.We can also use INDIRECT to return as worksheet reference. If ref_text is not a valid cell reference, INDIRECT returns the #REF! error value.
Syntex
Convert any text or number in reference with using INDIRECT formula.We can also use INDIRECT to return as worksheet reference. If ref_text is not a valid cell reference, INDIRECT returns the #REF! error value.
 |
| Example 1 |
Syntex
INDIRECT(ref_text, [a1])
- ref_text Required a valid cell reference.
- a1 - [optional] A boolean to indicate A1 or R1C1-style reference. Default is TRUE = A1 style.
| reference | amit |
6/box-posts/recent
| Value | Value2 |
| Apple | |
| Goods | |
| 4652 | |
| 50% | |
| -100 | |
| 405.5 | |
| Non-empty Cells | |
| 7 | |
Post a Comment