Part II: Working with Formulas and Functions
328
If two values in the Data range are equidistant from the Target value, the formula uses the first one
in the list.The value in ColOffset can be negative (for a column to the left of Data), positive (for a column to
the right of Data), or 0 (for the actual closest match value in the Data range).To understand how this formula works, you need to understand the INDIRECT function. This
function’s first argument is a text string in the form of a cell reference (or a reference to a cell that
contains a text string). In this example, the text string is created by the ADDRESS function, which
accepts a row and column reference and returns a cell address.