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
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!

     

Resources