Vlookup column number problem

Occasional Visitor


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


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