Dragging Formula Down Column Returns Row Values

This would work:

Formula:

=INDEX('Cash Flow'!$A$13:$IV$13,1,ROW(A1)+6)

The last formula I posted was too volatile (H/T Paul)

- Vince

assuming that "=G12, =H13, =I13" was meant to be "=G13, =H13, =I13", and without seeing what you are working with, use absolute...

=G$13 when you copy/drag this down or across, row 13 will remain fixed, but the column reference will adjust as you copy it across

if this was not what you wanted, please upload a sample workbook, showing what you have and a few examples of what you want



To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.