=INDIRECT(ref_text, [a1])
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!
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.
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k
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.
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.