INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
INDIRECT Function has one required argument i.e. ref_text, and optional argument i.e.
=INDIRECT(ref_text, [a1])
ref_text argument is used to give the text/string that you want to convert into cell reference.
[a1] argument denotes that, what type of style is available in ref_text argument.
Here, we have sample database and want to convert texts into cell reference:
We will be using INDIRECT function as follows:
– If no value or “TRUE” provided in [a1] argument, by default it considers ref_text as A1 style
– If [a1] argument is “FALSE” then it considers ref_text as R1C1 style
–A1 style means: columns are presented using letters (A-Z) and rows using numbers (1,2,3…)
–R1C1 style means: rows are presented using R1, R2, R3… and columns are presented using C1, C2, C3.
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
Excel Function ISERROR Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any…
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.
MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the…
Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.