| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
| How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
Linear Mode
