Ted Lewis (born 18 October 1969 in Bellingham, Massachusetts) is an American voice actor who does work for 4kids Entertainment, Central Park Media, TAJ Productions, DuArt Film and Video, and NYAV Post. Primarily, he is involved with anime dub voice work. He is also known as Ed Paul.
If you want to use the value of a cell in a formula in another cell of the spreadsheet, then you refer to this cell by means of its cell address. This cell address consists of a column indicator and a row number, e.g. cell D14 is the cell in column D, row 14.
More often than not, the ADDRESS function is used as an intermediate step to generate a cell address and then use that as the input to the INDIRECT function. By using a combination of ADDRESS and INDIRECT functions, you can complete a full circle â starting from reading the address of the cell and then using that address to return the value stored at that address. In the example above, we check for the accuracy of the returned address by using it as the input to in INDIRECT function.