| 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 |
| 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) | |||
Threaded Mode
