47.8 Using a single Bilink to a range of cells

If a link is created to a named range of cells, the Bilink() function's index argument is followed by two more integer arguments — the row and column of the desired cell within the range. For example...

Bilink(1; 10; 2)

... will retrieve the value from Bilink number 1, in row 10 and column 2 of the Bilink's region of cells.

This feature is demonstrated in the Bilinks tutorial example Bilink-range.trex and Bilink-range.xls. (This model exisits only to demonstrate how to reference a range of cells). The figure below shows the details of how you can use the Bilink options to get different outputs from the range of Excel cells.