is there a way to direct excel to get the value at a certain cell?

[bigdan]

Let's see I have a few cells which have cell references. So for example A1:A4 have the values K10, B3, X20, B6


[TABLE="width: 500"]
<tbody>[TR]
[TD]K10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Is there a way I can get the values at those cell references and put them in the corresponding cells in col B?

 

[Eric W]

Try:

=INDIRECT(A1)