Line Reference in Formula
Try this:
=INDIRECT("L"&A1)
If A1 = 45 the formula will return the contents of cell L45.
Biff
"Felix" wrote in message
...
Is it possible to include a number in a cell as line reference in a
formula?
Example: Cell A1 = 45; Formula in C5: = (any column, say) L45
--
Felix
|