View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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