Friday, January 30, 2009

Excel Vlookup function - Entering column number

Many users find it difficult to count and enter column number in Excel vlookup formula. This looks more difficult when the number of columns in the data range are large and gets complecated in case some of columns are hidden. However Microsoft Excel has inbuilt feature by which it helps you to know the column number. At the time of selecting table array it shows you the number of columns selected. If you notice this at the time of selection, you actualy do not need to count the number of columns. This works even if you have hidden columns in your data. Pls see video for further explanation.


  1. Hi!!
    How to do Vlookup with values in visuble columns(some columns were hide)?

  2. Hi!!

    You are having a very good collection of Excel tutorials. May be you want to look at my blog Mash2Blog for some computer tutorials articles.

  3. Hi there, I am at your website but still cant figure how out the answer to the question of this video. I appreciate the reply and thanks!


Learn how to create Excel dashboards.
Yogesh Gupta's Excel Tips