I've got what I think is a simple question. I've looked through several threads and don't see a similar question.
I have this formula =INDEX($B$2:$V$3,1,2)
I'd like to drag the formula vertically and it grow like this:
=INDEX($B$2:$V$3,1,2)
=INDEX($B$2:$V$3,1,3)
=INDEX($B$2:$V$3,1,4)
Any help would be greatly appreciated. Thanks!
You can't get those numbers to change by dragging. However, you can make it a reference to the row numbers. For example, suppose your formula starts in row 2 and you want to drag it down. Use this:
Formula:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
If you use ROWS you don't need to worry about which row you start in. Try this and drag/copy it down:Formula:Please Login or Register to view this content.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
You can increment that number by using the cell reference of the first cell the formula is entered in.
For example, let's assume you want to enter the first formula in cell A2 and copy down such that:
A2: =INDEX($B$2:$V$3,1,2)
A3: =INDEX($B$2:$V$3,1,3)
A4: =INDEX($B$2:$V$3,1,4)
Enter this formula in A2 and copy down as needed:
=INDEX($B$2:$V$3,1,ROWS(A$2:A2)+1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Re: Index question
Try this..
Formula:Please Login or Register to view this content.
Drag Down..
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Using the ROW function leaves the formula vulnerable to new row insertions.
More robust to use ROWS(...).
Thanks for suggestion Tony..
Amended one..
Formula:Please Login or Register to view this content.
Wow, thanks so much everyone. It would have taken me awhile to figure that one out. It's working perfectly. I'll mark this as solved and add reputation marks.
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks