Is there a formula to allow for dragging a function across columns but refencing down a row?
Example in row 1, C1 referenced to A4, dragging the formula right so it references in D1 to A5
Here is what I've got, and I'd like to drag across from C1 to Z1, with Z1 looking for data in A26
Please Login or Register to view this content.
Last edited by Christopherdj; 01-29-2015 at 06:55 PM.
Try something like this...
=INDEX($A4:$A26,COLUMNS($C1:C1))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Ahh, thanks for that. Now I realise, I've got merged cells across row 1. So C1 actually covers C1, D1 and E1, is there also a way to deal with this? CDE1 refers to A4, FGH refers to A5.
Try this...
=INDEX($A4:$A26,CEILING(COLUMNS($C1:C1)/3,1))
Kewl - thanks for that, works fine.
Good deal. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks