Jumping five steps

A

Arne Hegefors

I have two lists in excel say column A and B. In cell A1 I want to show the
value found in B1. In A2 I want to show the value found in B5, in A3 I want
to show the value found in B10, in A4 B15 etc. How do you do this in Excel? I
usually work with vba so i have completely forgotten!
 
R

robert111

you could create a dummy column with 5,10,15,20 etc in column C an
then use an offset function containing a match function

in A2

=offset($b$1,C2,0
 
B

Bob Phillips

Do you really want B1, B5, B10, or B1,B6,B11?

Assuming the second

=INDEX(B:B,(ROW(A1)-1)*5+1)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
A

Arne Hegefors

Hi Bob! Yes you are right, I want to jump five steps. However I do not seem
to get your code to work. I really dont know what is wrong and I have some
foregin version of excel so i cannot understand the help function. I just get
the text #NAME? in the cells in column A. Please help me out! Thanks very
much!!

"Bob Phillips" skrev:
 
B

Bob Phillips

Which foreign version?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

Is it Swedish?

=INDEX(B:B;(RAD(A1)-1)*5+1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
A

Arne Hegefors

yes! Thanks alot bob! It works like clockwork now! Thanks!

"Bob Phillips" skrev:
 
B

Bob Phillips

What about your other post, do you want that in Swedish?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top