View Single Post
Old 07-19-2016, 02:49 PM   #17
polak
In the Sin Bin
 
Join Date: Aug 2012
Exp:
Default

Quote:
Originally Posted by ResAlien View Post
...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...)?
polak is offline   Reply With Quote