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

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

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