Which foreign version?

--
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!