Auto fill data with INDIRECT formula

[glosos]

Hi.

I have a formula in my excel, which I want to extend down and to the right.

=INDIRECT($B$2&"!T3252")

In B2 I have a drop-down with different countries, which match the tab names. So, If I select 'Germany' in B2, the formula returns the content of the cell T3252 from tab 'Germany' ... You get the picture.

What I would like, is to copy the formula down and to the right, so it will return the content of T3253 in the cell bellow and U3252 in the cell to the right.

How can I do that?

[martindwilson]

=INDIRECT($B$2&"!"&ADDRESS(ROW(T3532),COLUMN(T1))) should do it

[ChemistB]

Try this
=INDIRECT($B$2&"!" & ADDRESS(ROWS($A$1:$A3252),COLUMNS($A$1:T$1)))

Dang you Martin. I'm too slow.

[glosos]

Thank you for the response, but this doesn't seem to work. It should, though, since I got two the same answers

The formula does not return any values, it only shows the formula itself.
The fx button indicates an error in the 'address' part of the formula.

I am sorry if there is some stupid mistake I make every time, which causes the problems

[Tony Valko]

Try this...

=INDIRECT($B$2&"!"&CELL("address",T3252))

[Tony Valko]

The formula does not return any values, it only shows the formula itself.

That sounds like the cell is formatted as TEXT.

Change the cell format to General then re-enter the formula.

[martindwilson]

also you might need to replace the comma , with a semicolon ;

[glosos]

It was the comma!

Thank you so much for a quick response by everybody!