Vlookup column number problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2859922%22%20slang%3D%22en-US%22%3EVlookup%20column%20number%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2859922%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E2%20weeks%20ago%20my%20laptop%20changed%20and%20so%20do%20all%20the%20applications.%20With%20the%20new%20excel%2C%20I%20can%20not%20find%20the%20column%20number%20and%20with%20sheets%20that%20has%20columns%20like%20AD%2C%20AE...%20etc%20%2C%20I%20have%20to%20count%20one%20by%20one%20to%20find%20the%20referred%20column%20number.%20I've%20attached%20picture%20from%20both%20my%20old%20and%20new%20excels.%20Our%20company%20IT%20has%20also%20intervened%20without%20any%20solution.%20My%20excel%20version%20is%3A%202102%20(Build%2013801.20960).%3C%2FP%3E%3CP%3EHave%20you%20ever%20seen%20such%20a%20problem%3F%20Or%20do%20you%20have%20any%20idea%20to%20solve%20it%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2859922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2860395%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20column%20number%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2860395%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1189475%22%20target%3D%22_blank%22%3E%40bluemaniac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20to%20keep%20the%20mouse%20button%20down%20while%20selecting%20the%20range.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

2 weeks ago my laptop changed and so do all the applications. With the new excel, I can not find the column number and with sheets that has columns like AD, AE... etc , I have to count one by one to find the referred column number. I've attached picture from both my old and new excels. Our company IT has also intervened without any solution. My excel version is: 2102 (Build 13801.20960).

Have you ever seen such a problem? Or do you have any idea to solve it?

Thanks in advance...

1 Reply

@bluemaniac 

You have to keep the mouse button down while selecting the range.