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

--
HTH

Bob Phillips

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

"Arne Hegefors" wrote in message
...
yes! Thanks alot bob! It works like clockwork now! Thanks!

"Bob Phillips" skrev:

Is it Swedish?

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

--
HTH

Bob Phillips

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

"Arne Hegefors" wrote in
message
...
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:

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)

"Arne Hegefors" wrote in
message
...
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!