Forum Discussion
Count vlookup columns
Do you mean the small box that shown in below screenshot?
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 AmairahDec 21, 2017Silver Contributor
Take a look at the left-hand corner of the Excel window, you may find it there as shown in the below screenshot!
- Kimberly JiangDec 21, 2017Copper Contributor
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!
- Dec 21, 2017
You're welcome!
- 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?
- Stanford2058Jan 19, 2019Copper Contributor
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.
- rmarques.brOct 10, 2018Copper Contributor
I have the same case here. The only situation where it works is when the reference is inside the same workbook. The column count reference doesn't work when the formula is in one place and the reference in the other.
Anyone has any idea on how to enable this column count?
It looks like a "new instance" issue... some other errors used to happen with vlookup formula when working on different instances...the difference now is that the error occurs even in the same instance.
- Kimberly JiangDec 21, 2017Copper Contributor
I'm using Microsoft Office 365 ProPlus, version 1711 (Build 8730.2127).
I'm able to see the tooltip in the second image you posted, but not the first. Below is a screenshot of what I see when I try to highlight the columns. There is no tooltip at all.
- RohanAug 08, 2018Copper Contributor
hi All,
Same problem with my excel O365 - mine version is 1805 - excel proplus
pls help?