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

8 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?

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

    • melih says:

      Hi. Sadly I am looking for a solution to this.
      When I manage to fşnd one, I will post here right away.
      Best regards…

    • Judy says:

      I am having the same issue and just switched to using 2 monitors. Darn if the count didn’t show up on the other monitor that I wasn’t using the file on. Try looking on your 2nd screen to see if the counts are showing up there. Good Luck

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.