Line Reference in Formula

F

Felix

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
 
T

T. Valko

Try this:

=INDIRECT("L"&A1)

If A1 = 45 the formula will return the contents of cell L45.

Biff
 
F

Felix

And if the Column is on anoth sheet?

(The values to be brought into the new cell with the formula in sheet 2 are
in column B on Sheet 1, the line number is on sheet 2)
 
I

Ingolf

Hi,

simply add the name of the spreadsheet ahead of the cell reference,
separated by an exclamation mark:

=INDIRECT("Sheet1!B"&A1)

Ingolf
 
Top