ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Value in a cell as address of another cell (https://www.excelbanter.com/excel-discussion-misc-queries/212469-value-cell-address-another-cell.html)

KaZetE
Value in a cell as address of another cell
 
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
Value in a cell as address of another cell
 
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

Vijay Chary
Value in a cell as address of another cell
 
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" 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

KaZetE
Value in a cell as address of another cell
 
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

KaZetE
Value in a cell as address of another cell
 
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 wiadomosci ...
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

Pete_UK
Value in a cell as address of another cell
 
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 -

KaZetE
Value in a cell as address of another cell
 
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 -

Pai
Value in a cell as address of another cell
 
Hey Try This

="B"&C13 in C1 and copy down


Hardeep kanwar


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

Pete_UK
Value in a cell as address of another cell
 
You're welcome - thanks for feeding back.

Pete

On Dec 4, 2:59*pm, "KaZetE" wrote:
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 ...
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 -- Hide quoted text -

- Show quoted text -


All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com