Value in a cell as address of another cell

[KaZetE]

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

 

[Pete_UK]

Put this in C1:

=INDIRECT("B"&A1)

and then copy down as far as you need to.

Hope this helps.

Pete

 

[Vijay Chary]

Hi KZE !!
Enter =Indirect("B" & A1) in the cell C. Copy
this formula down the column C. Now, in column B you would have the values
found in the row indicated by the number (in the cell in column A) , in
column B.

I hope this solves your problem !

 

[KaZetE]

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" <[email protected]> napisal w wiadomosci
Put this in C1:

=INDIRECT("B"&A1)

and then copy down as far as you need to.

Hope this helps.

Pete

 

[KaZetE]

It is probably connected with language version of Excel.
I am just trying to find a substitute of INDIRECT in my
version.

Regards
KZE

 

[Pete_UK]

What language version are you using?

Pete

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" <[email protected]> napisal w wiadomosci






- Show quoted text -

 

[KaZetE]

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" <[email protected]> napisal w wiadomosci
What language version are you using?

Pete

 

[Pai]

Hey Try This

="B"&C13 in C1 and copy down


Hardeep kanwar

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

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" <[email protected]> napisal w wiadomosciWhat language version are you using?

Pete




- Show quoted text -