formula question

[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

 

[Frank Kabel]

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

 

[Norman Harker]

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.