referencing a field in another worksheet

Hi,

So here's what I've got:

I have a field with a column and row number (e.g.: B26) in one worksheet and I want to reference that field in another worksheet.

When I do this it returns B26 (obviously)... but I was wondering is there any way to look at the field with the B26 in it and for that to return what is actually in the B26 field?

Confusing i know...

Cheers
Rick

Hi

Have a look at the INDIRECT function.

Say you have B26 in A1, and in B26 you have 50, then

=indirect(a1) will return 50.

You don't say what sheet you want to reference, but if you are on sheet1, and you want to reference sheet2, then

=indirect("sheet2!"&a1)
will bring back the value from sheet2!B26.

HTH

rylo