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

K10
B3
X20
A6

<tbody>
</tbody>

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)