Forum Discussion
Pulling info consistently from two cells right of original target
Thanks for helping. I Have one cell (S4) where I am using ‘=C1’ to extract info. I would like to pull info from E1 (two cells to the right) and place in S5. Further down, I want to use ‘=C5’ in cell ...
=IF(ISEVEN(ROW()),INDEX(C:C,ROW($C$2)*(ROW(C1)-ROW($C$1))+1),INDEX(E:E,ROW($C$2)*(ROW(C1)-ROW($C$1))-1))Does this return the expected result?
- When I entered the formula in S4, it highlighted columns C and E, but returned no result in S4. I'm not sure how that was supposed to work - got lost in the flow (which is very easy for me to do).
Does it show the expected result when you open the attached file? If there isn't an entry in cell C1 then the formula returns 0 in cell S4. If E1 is empty the formula returns 0 in cell S5.