Hi Guys,
I need to have my formula move opposite direction.
For example, if in Cell A2, I have "=A1*2", and normally, if I drag the cell down, Cell A3 will have "=A2*2", but that's not what I need. I need it to be B2*2 (So the formula refers vertical not horizontal).
Is there a way to do that?
Thank you!
Jolene
PS. Sorry about the typo for the title... didn't realize it till I post it
Last edited by zbor; 03-17-2014 at 03:31 AM.
Here:
Formula:
Please Login or Register to view this content.
PS: I've editet typo
Never use Merged Cells in Excel
In A2 Cell
=INDEX(1:1,,ROW(1:1))*2
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you guys! So, will it work if my formula is kinda big?
My actual formula in cell A1 is:
=IFERROR(INDEX(Sheet1!C1:C16699,MATCH($E$1&$E$2,Sheet1!$BS$1:$BS$16263,0)),"")
So when I drag it down, I want it to be:
=IFERROR(INDEX(Sheet1!D1:D16699,MATCH($E$1&$E$2,Sheet1!$BS$1:$BS$16263,0)),"")
(underline is the difference)
And thank you zbor for changing the typo
Try this....
=IFERROR(INDEX(INDEX(Sheet1!C1:C16699,,ROW(1:1)),MATCH($E$1&$E$2,Sheet1!$BS$1:$BS$16263,0)),"")
sorry
Oops... try this...
=IFERROR(INDEX(INDEX(Sheet1!$C$1:$XFD$16699,,ROW(1:1)),MATCH($E$1&$E$2,Sheet1!$BS$1:$BS$16263,0)),"")
Hi Sixthsense, thank you! I will try that later tonight.
Sent from my iPhone using Tapatalk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks