Guy's I got a basic problem here that if you answer will help me save time. Thanks in advance.
I'm using the index match function to pull data. And I can drag the function to the right to populate more columns and that works for me. But the problem is that match is inside of that function, and when I drag it right I don't know how to lock in the "lookup value" of match so that the lookup value stays the same even though the formula is being dragged to cells right of it.
It's one of those lookup values that say It won't let me type the at symbol anywhere on this post cause I'm newer... jeeze But it's the cell with the at symbol and then names a cell title
"[at symbolcell title]"
and I tried putting the $ symbol at each part of this to try to lock in the cell and it won't work. I tried putting the $ in between each thing and before it. So I don't know what to do.
Here's a sample workbook, but it isn't the greatest lol.. basically the point is that i'm dragging all these SPX returns, all of these returns on the different indexes, i'm dragging that formula to the right, and I can't lock the cell of the [Datevalue] so I gotta copy and paste that into each formula.
Thanks
Bookmarks