Difficulties in using Excel table common functions

1. INDIRECT(ref_text, logical value)
Returns the reference specified by the text string. This function immediately evaluates the reference and displays its contents.
Ref_text, text reference description,
(1) A1-style reference (logical value, T, default)
(2) R1c1-style reference (logical value, F, R1C1 style)
(3) a name defined as a reference or a reference to a text string cell

with insert-name mode, give this cell the name George) 62 td>10   ( A B B2 1.333 B3 the George 5 formula description (Result) =indirect ("A2") cell A2 =indirect (A2) cell A2 values in the reference B2 (1.333) =indirect ($A $) value of reference B3 in cell A3 =indirect ($A $4) Returns the value of the definition name if the cell B4 has a definition named "George" =indirect ("B" & $A $) reference value in cell A5

Generally with the address together, the effect is better.
ADDRESS (num[line number],num[ column number],num[reference type],a1,text[sheet name ])
Returns the address of a specific cell, given the line number and column number.
Address(2,3,4) to C2
Address(2,3) for $C

Difficulties in using Excel table common functions