<HELP modified reference
 

Hi, please help with the following:

I have formula that refers to one cell (lets say A5=B3). When i copy formula
from A5 to A6 (down verticaly), A6 refers to B4 (reference shifts down too).

What should I do to make reference to shift horizontaly? (after copying
formula verticaly to A6, reference should shift horizontaly to C3, not
verticaly to B4) Is this possible and how?

<HELP modified reference
 

Use =INDEX($3:$3,,ROW(A2))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"referrrrrr" wrote in message
...
Hi, please help with the following:

I have formula that refers to one cell (lets say A5=B3). When i copy
formula
from A5 to A6 (down verticaly), A6 refers to B4 (reference shifts down
too).

What should I do to make reference to shift horizontaly? (after copying
formula verticaly to A6, reference should shift horizontaly to C3, not
verticaly to B4) Is this possible and how?