Using a column in If Else statement

**DonkeyOte** · 03-15-2010, 08:39 AM

Yes, change the last formula you posted in line with the prior suggestion
(modify the Row element of the INDEX to use the 255 MOD rather than the Column element of the INDEX as attempted previously)

Please do not quote entire posts in your reply - this is just clutter.

**Izeath** · 03-15-2010, 10:45 PM

=INDEX($D3:$K$2108,1+MOD($B3,255),1+MOD($B3,8)) I have done this, but it just goes down for 40 cells it is in the column H (89) and it gets the value of 61 but the MOD 255 of B3 is 84. So it must go down 84 cells? What must be the problem?

**DonkeyOte** · 03-16-2010, 04:54 AM

Post a sample - illustrate desired results for a number of different scenarios.

**Izeath** · 03-19-2010, 08:14 AM

For example i have only 1 column and it has many rows lets use the column D, is it possible that doing MOD(B3,8) drops down to 4 and selects the 215 value, for MOD(B4,8) is 0 it will select 91 and for MOD(B5,8) is 5 it will start at 221 and drops down to the value of 110 and selects it? It is like a series.

**DonkeyOte** · 03-19-2010, 08:19 AM

by the below I meant a file...

Originally Posted by DonkeyOte

Post a sample - illustrate desired results for a number of different scenarios.

**Izeath** · 03-19-2010, 11:54 PM

It is like this.

**DonkeyOte** · 03-20-2010, 06:44 AM

Using the attachment in prior post in conjunction with narrative in post #19 perhaps you want:

G3: =1+MOD($B3,8)
copied down

F3: =INDEX($D$3:$D$2108,SUM($G$3:$G3))
copied down

**Izeath** · 03-21-2010, 03:20 AM

Thanks for the help! i added another column to satisfy the value that needs to be selected which is =G4+1 (copied down). I really appreciate the help! Thank you very much!