Quote:
Originally Posted by ResAlien
...shift and enter you say? What sorcery is this. Goddammit now I feel stupid.
No, that didn't fix it I don't think. Odd. I don't know what the hell
So like this is what happens. I do =vlookup(A2,alt/tab to my other sheet, A2 again and hold down shift, go over two rows to what I want, and as soon as I I go to hit the down arrow and ctrl along with shift it reacts like I've hit enter to end my formula.
That explanation was probably terrible.
|
Are you sure it's catching you change to the other sheet? So does it show =vlookup(A2,Sheet2!A:X,etc...)?