Get cell reference address

[Vadims Podans [MVP]]

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?

 

[Sheeloo]

I think you need to learn VLOOKUP

Look in HELP or visit Debra's excellent site -
http://www.contextures.com/xlFunctions02.html

 

[Vadims Podans [MVP]]

Excellent! Thanks!