Jumping five steps
 

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!

Jumping five steps
 

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

in A2

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=567836

Jumping five steps
 

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!

Jumping five steps
 

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!

Jumping five steps
 

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!

Jumping five steps
 

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!

Jumping five steps
 

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!

Jumping five steps
 

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!