Line Reference in Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this:

=INDIRECT("L"&A1)

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

Biff
 
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)
 
Hi,

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

=INDIRECT("Sheet1!B"&A1)

Ingolf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Macro Question 17
Last Modified By in a cell by user 3
Add a cell to a fomula already in a cell and keep the formula 4
Reference Formula Help 1
Reference to another worksheet cell in a sumproduct formula 1
Using one cells formula in multiple other cells 1
Transpose between sheets 4
Contents 1

Back
Top