Don’t Count Columns for Vlookup

If you are using Vlookup function like everybody, you are likely to count columns while writing your formula. Don’t count columns for Vlookup anymore, because Excel already shows you how many columns are selected.

You may find how to use Vlookup Function here.

As a part of it’s syntax, you need to specify from which column you want to lookup values. To do that, you need to input a number indicating how many columns to the left your vlookup formula needs to go.

People generally tends to count columns during writing vlookup formulas. It can be manageable with a couple of columns to count. But when you have to many columns to count (like 40-50) it can be quite unpleasant.

Don’t count columns for Vlookup, because while selecting table array your vlookup formula, Excel shows you how many columns are selected. You can use this information as your column index number without counting columns again.

You may also like...

7 Responses

  1. Gopinath says:

    Use vlookup without enter columns no

  2. amed says:

    for some reason my excel doesnt show column count.. can you help?

    • melih says:

      Hi. Unfortunately, I don’t know why it is dissepared or how to restore it back. People on microsoft forums say that they could restore that tool tip by reinstalling excel.

  3. Pete says:

    Thank you for this!

  4. Niki says:

    Hi, I am wondering whether you are able to ‘static’ the position of the column count pop up box – I work on dual screens and it pops up in random places each time – I have to look all over my screens to find it each time which is frustrating – it doesn’t just come up in the same place each time – do you know if there’s anyway of fixing this?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.