It works! Thank you very much.

I use Polish version of Excel 97 and 2007.
In my version the function is called ADR.POSR
where S is with dash above the letter because
it is a Polish diacritic character.

Regards
KZE


Uzytkownik "Pete_UK" napisal w wiadomosci
...
What language version are you using?

Pete

On Dec 4, 2:41 pm, "KaZetE" wrote:
It is probably connected with language version of Excel.
I am just trying to find a substitute of INDIRECT in my
version.

Regards
KZE

Uzytkownik "KaZetE" napisal w a.pl...



Pete, thank you for your reply.

First I tried in MS Excel 97, in which I have to solve the problem.
It didn't find "INDIRECT" so I thought it'd work in a newer version
of Excel.
I have just tried it in MS Excel 2007 and "INDIRECT" is not recognised
either.

Should I do anything else before trying it?

Regards
KZE

Uzytkownik "Pete_UK" napisal w wiadomosci
...
Put this in C1:

=INDIRECT("B"&A1)

and then copy down as far as you need to.

Hope this helps.

Pete

On Dec 4, 1:28 pm, "KaZetE" wrote:
Hi,

There are 3 columns A, B and C.
Column A contains numbers which represent some of rows in a sheet,
for example:
A1=1245
A2=48
A3=1548
A4=3
A5=965
etc.
In column B there are any values.
I would like to copy the values from column B into column C in following way:
C1 = B1245
C2 = B48
C3 = B1548
C4 = B3
C5 = B965
etc.
It means that numbers in column A should indicate rows in column B.

I don't know how to do it.
Could anyone help me, please?

Regards
KZE- Hide quoted text -

- Show quoted text -