Forum Discussion

Kimberly Jiang's avatar
Kimberly Jiang
Copper Contributor
Dec 20, 2017

Count vlookup columns

Hello,   My computer recently updated its Excel Office 365 version.  Prior to the update, whenever I performed a vlookup, for the second input, I would usually highlight the columns from which I ...
Formulas & Functions
Need Help
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 20, 2017

Do you mean the small box that shown in below screenshot?

 

  • kamil shah's avatar
    kamil shah
    Copper Contributor
    Nov 13, 2018

    Haytham Amairahi faced the same problem with MSO 365 , but my case is if i look into a less columned document i am able to see the number of columns. If a try to fetch into a document which have a lot of column and the document size is not fitted to the default screen it can show up to 10 or 11 columns number than the info disappear.

    Kindly help on that.

    Thanks in advance.


    MSO 365 user

  • Kimberly Jiang's avatar
    Kimberly Jiang
    Copper Contributor
    Dec 20, 2017

    Yes.  The box only appears when I highlight a block of cells, but it no longer appears when I highlight columns for the vlookup.

     

    As a note, it DOES still appear when I highlight columns by themselves apart from the vlookup, but when I am highlighting during the vlookup, the column counter box no longer appears.

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Dec 21, 2017

      Take a look at the left-hand corner of the Excel window, you may find it there as shown in the below screenshot!

       

      • Kimberly Jiang's avatar
        Kimberly Jiang
        Copper Contributor
        Dec 21, 2017

        This is really strange, but I can suddenly see it again at the top of my screen!  (See screenshot).  This is different than the screenshot I posted yesterday.

         

        I'm not sure whether it was appearing at the bottom of my screen yesterday as you suggested, perhaps it was and I just missed it.  As far as I know though, I don't think I did anything differently to move it back to the top today.  Maybe there was a software update overnight or something.  Nevertheless, thank you Haytham and Ingeborg for your replies!

         

    • IngeborgHawighorst's avatar
      IngeborgHawighorst
      MVP
      Dec 20, 2017

      Hello,

       

      what is your Excel version? I run Office 365 with the monthly channel and I see a box with the information at the top of the column headers when I select whole columns in the Vlookup formula ....

       

       

      ... and a tool tip at the bottom of the selection when I select a range instead of whole columns. Do you not see these?

       

      • Stanford2058's avatar
        Stanford2058
        Copper Contributor
        Jan 19, 2019

        Hello,

        I can see the column number as you show, but I have another problem may be you could help me.

        after using office 365, in the vlookup function, I could not go to the end of the selected columns by shortcut function. before I used control+spacebar, now it would not work.  I tried to use other suggestions googled online, but nothing works.

        Thanks in advance for any suggestion.

Resources