Formula

  • Thread starter Thread starter Alexander
  • Start date Start date
A

Alexander

Hi all.

In cell B1 I have formula (right in the cell) as:

=MyWSheet!C128

The cell A1 value is 128.

How can I write next in cell B1 (but to work as formula, not to be
text-data):

=MyWSheet!C&"A1" or
=MyWSheet!C&"A1.value" or simillar?

Tnx in advance.

Alex
 
Hi Alexander!

Use:

=INDIRECT("MyWSheet!C"&A1)

--
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.
 
Ah guys... what a nice one. You new about that:) So fast... I didn't know
about indirect.

Thanks a lot to Dale Hymel and Norman Harker.
 
You can know alot about Excel, and still not know enought to keep you out of
trouble. Someone is always changing things.
 
Exactly. And you know what? IF you don't work with all of that about year or
so...:)) you'll need some time to come back:) I've found indirect in
formulas:) Ellegant.
 
Back
Top