Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get cell reference address
Hi!
I'm interesting about this task. I have a table with data like this: N.p.k. Nosaukums ID Svars Iepakojums Cena USD par 100m Cena LVL par 1m Cena GBR par 1m 1 Svīna lenta 5 317 050 50g/m 50m $19,81 Ls 0,11 £0,18 2 Svīna lenta 5 317 068 68g/m 50m $25,77 Ls 0,15 £0,24 3 Svīna lenta 5 317 085 85g/m 50m $30,91 Ls 0,18 £0,28 4 Svīna lenta 5 317 100 100g/m 25m $36,33 Ls 0,21 £0,33 5 Svīna lenta 5 317 150 150g/m 25m $52,05 Ls 0,30 £0,48 <... table contains about 1000 lines. and I want to create another table, that will contains only several lines and columns from main table. I can use simple cell reference by ID column. For example, cell J1 refers to C5, J2 refers to C8, J3 refers to C20, etc. To automate this process I want to use these reference links to automatically obtain other columns (actually values from "Cena LVL par 1m column") values using something like this: =OFFSET(J1;0;4) however this line will takes J1 cell value and I want to go through J1 reference (which refers to C5) and read value from C5. Is this possible? -- WBR, Vadims Podans MVP: PowerShell PowerShell blog - www.sysadmins.lv |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get cell reference address
I think you need to learn VLOOKUP
Look in HELP or visit Debra's excellent site - http://www.contextures.com/xlFunctions02.html ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Vadims Podans [MVP]" wrote: Hi! I'm interesting about this task. I have a table with data like this: N.p.k. Nosaukums ID Svars Iepakojums Cena USD par 100m Cena LVL par 1m Cena GBR par 1m 1 Svīna lenta 5 317 050 50g/m 50m $19,81 Ls 0,11 £0,18 2 Svīna lenta 5 317 068 68g/m 50m $25,77 Ls 0,15 £0,24 3 Svīna lenta 5 317 085 85g/m 50m $30,91 Ls 0,18 £0,28 4 Svīna lenta 5 317 100 100g/m 25m $36,33 Ls 0,21 £0,33 5 Svīna lenta 5 317 150 150g/m 25m $52,05 Ls 0,30 £0,48 <... table contains about 1000 lines. and I want to create another table, that will contains only several lines and columns from main table. I can use simple cell reference by ID column. For example, cell J1 refers to C5, J2 refers to C8, J3 refers to C20, etc. To automate this process I want to use these reference links to automatically obtain other columns (actually values from "Cena LVL par 1m column") values using something like this: =OFFSET(J1;0;4) however this line will takes J1 cell value and I want to go through J1 reference (which refers to C5) and read value from C5. Is this possible? -- WBR, Vadims Podans MVP: PowerShell PowerShell blog - www.sysadmins |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get cell reference address
Excellent! Thanks!
-- WBR, Vadims Podans MVP: PowerShell PowerShell blog - www.sysadmins.lv "Sheeloo" just remove all As... rakstīja ziņojumā "... I think you need to learn VLOOKUP Look in HELP or visit Debra's excellent site - http://www.contextures.com/xlFunctions02.html ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Vadims Podans [MVP]" wrote: Hi! I'm interesting about this task. I have a table with data like this: N.p.k. Nosaukums ID Svars Iepakojums Cena USD par 100m Cena LVL par 1m Cena GBR par 1m 1 Svīna lenta 5 317 050 50g/m 50m $19,81 Ls 0,11 £0,18 2 Svīna lenta 5 317 068 68g/m 50m $25,77 Ls 0,15 £0,24 3 Svīna lenta 5 317 085 85g/m 50m $30,91 Ls 0,18 £0,28 4 Svīna lenta 5 317 100 100g/m 25m $36,33 Ls 0,21 £0,33 5 Svīna lenta 5 317 150 150g/m 25m $52,05 Ls 0,30 £0,48 <... table contains about 1000 lines. and I want to create another table, that will contains only several lines and columns from main table. I can use simple cell reference by ID column. For example, cell J1 refers to C5, J2 refers to C8, J3 refers to C20, etc. To automate this process I want to use these reference links to automatically obtain other columns (actually values from "Cena LVL par 1m column") values using something like this: =OFFSET(J1;0;4) however this line will takes J1 cell value and I want to go through J1 reference (which refers to C5) and read value from C5. Is this possible? -- WBR, Vadims Podans MVP: PowerShell PowerShell blog - www.sysadmins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert ADDRESS() text result to cell reference | Excel Worksheet Functions | |||
Cell address without absolute reference | Excel Worksheet Functions | |||
How do I get the cell address of a VLOOKUP reference? | Excel Worksheet Functions | |||
how to make cell address reference increment? | Excel Worksheet Functions | |||
Using result from ADDRESS function as a cell reference itself | Excel Worksheet Functions |