formula question

  • Thread starter Thread starter Yakov Goldin
  • Start date Start date
Y

Yakov Goldin

Sorry if this question was asked before.
Lets say in A1 I have a formula =B1. It means the content (or value) of A1
equals to content of B1. Now, lets say I want the value of A1 be equal to
some cell in column B, but not neccesary the first. I want to be able to
manually enter a cell number from the column B where A1 should take its
value. Any ideas how to do that?

Thank you,
Yakov
Electrical Engineer
 
Hi Yakov

lets assume you enter the cell number in C1 the insert the following in
A1
=OFFSET($B$1,$C$1-1,0)

Frank
 
Hi Yakov!

Use:

A1:
=INDIRECT(B1)

A1 will return the value of the cell reference in B1

In addition to a simple reference to B1 you might build the reference:

Example: Where B1 contains a Column reference
=INDIRECT(B1&27)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top