| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
<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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
<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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Circular reference toolbar not working | Excel Discussion (Misc queries) | |||
| How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Hybrid Mode
