Hi!

=INDIRECT("Sheet2!A"&COLUMN(B:B))

The Indirect function takes TEXT representations of references and
"converts" them to useable formula references.

In this example the TEXT string "Sheet2!A" is concatenated with the result
of the COLUMN() function to produce the TEXT representation that INDIRECT
can use as a formula reference.

The COLUMN() function returns the column NUMBER of it's argument. In this
case column B is the second column so:

COLUMN(B:B) = 2

You could also express that as:

COLUMN(B1)

The Column function will ignore the ROW reference, in this case, 1.

So, Indirect uses the TEXT string:

"Sheet2!A2"

and "converts" it to the useable formula reference:

=Sheet2!A2

Biff

"SenojNW" wrote in
message ...

The INDIRECT function seems to work well...

Can you explain the formula a bit more for me - I like to understand
what it is doing... :)


--
SenojNW
------------------------------------------------------------------------
SenojNW's Profile:
http://www.excelforum.com/member.php...o&userid=25958
View this thread: http://www.excelforum.com/showthread...hreadid=393746