INDIRECT formula in Microsoft excel || Part 01 || Convert a text value into a cell reference.
Microsoft Excel INDIRECT function returns a valid cell reference/range from a given text string. INDIRECT is useful when you want to convert a text value into a valid cell reference.
Syntax:
=INDIRECT (ref_text, [a1])
Arguments
ref_text - A reference supplied as text.
a1 - [optional] A boolean to indicate A1 or R1C1-style reference. Default is TRUE = A1 style.
===========================================================
Sharing is caring !!! Your responses will inspire me to upload more tutorial.💪💪
So...Share 🤝 || Like 👍 || Comment ✍️
• Our all youtube video:- https://www.youtube.com/c/mmbcampus?s...
• Excel VBA all video:- • How to use "IF, ElseIf, Else" in Excel VBA...
• Excel Formula all video:- • How to write Microsoft Excel Formula, Part...
• Ask your any question in facebook page / mmbcampus2016
• Visit https://www.mmbcampus.com to download all related file, if any.
====================================================================
INDIRECT formula in Microsoft excel || Part 02 || Explanation with example:
• INDIRECT formula in Microsoft excel || Par...