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.
skip to main |
skip to sidebar
Daily use tips for excel. Solution to frequently faced excel problems in simple manner.
Subscribe by mail
Recent Posts
Most Populor
Topics
- Add Spin Buttons ActiveX Controls (1)
- Adding non printing information to your worksheet (1)
- Auto Open Macro (1)
- Automating Tasks in Excel (1)
- calculating age (1)
- Convert Numbers to Words (1)
- Converting Text to date (1)
- countif array (1)
- countif multiple conditions (1)
- Countif Multiple Criteria (1)
- countif two criteria (1)
- countif with multiple criteria (1)
- Custom Functions (5)
- Defined Names (1)
- Deploy Macros Found Elsewhere (1)
- Disable Cut Copy Paste in Excel (1)
- Disable right click menu (1)
- Email Address Extract (1)
- EMI Calculator (1)
- Excel Addins (1)
- Excel Closest Match (2)
- Excel Currency Format (1)
- Excel Date Picker (1)
- Excel Formulas (8)
- Excel Kay Board Shortcuts (1)
- Excel Last Row (1)
- Excel Macros (33)
- Excel Number Format (2)
- Excel Pop up Calendar (1)
- excel subtotals (1)
- Excel Vlookup Function (2)
- Extract Number From String (1)
- Extract Number From Text (1)
- File Open (1)
- Find Duplicate (1)
- Find Last Row (1)
- Forcing users to Enable Macros (1)
- Forcing users to use updated version (1)
- Formating Cells in Excel (6)
- Formating Numbers in Excel (4)
- Get Number From String (1)
- Hardware Locking for Excel Workbook (1)
- Hide cell contents before printing (1)
- Indian Style Comma Separation for numbers (1)
- Learn Excel VBA (4)
- Logging User Activity (1)
- Macro Last Row (1)
- Macros in Excel (33)
- Making EMI Calculator (2)
- multiple countif (1)
- multiple sumif criteria (1)
- Numbers to Text (1)
- Pivot Tables (1)
- PMT Function in Excel (1)
- Profit and Loss report using Pivot Tables (1)
- Range Name Excel (1)
- Remove Duplicate (1)
- Send email with VBA (1)
- Show Developer Tab (1)
- Sorting Dates by Birthday (1)
- Spell Currency (1)
- SpellCurr() (1)
- subtotal excel (1)
- subtotal function excel (1)
- subtotal in excel (1)
- subtotals in excel (1)
- Sum Top 5 values in Unsorted Range (1)
- sumif multiple (1)
- sumif multiple criteria (1)
- Symbol Check Mark (1)
- Test if workbook is open or not (1)
- Text To Numbers (1)
- VBA Last Row (1)
- Visual Basic Grammar (4)
- Wingdings Check Mark with double click (1)
- Working with Data Range (5)
- Working with date function (8)
Recent Comments
View My Linkedin Profile
Stat Counter
Labels
Auto Open Macro
Convert Numbers to Words
Disable Cut Copy Paste in Excel
Disable right click menu
Excel Last Row
Excel Macros
File Open
Find Duplicate
Find Last Row
Forcing users to Enable Macros
Forcing users to use updated version
Formating Cells in Excel
Formating Numbers in Excel
Hardware Locking for Excel Workbook
Learn Excel VBA
Logging User Activity
Macro Last Row
Numbers to Text
Remove Duplicate
Symbol Check Mark
Visual Basic Grammar
Working with date function
Hi!!
ReplyDeleteHow to do Vlookup with values in visuble columns(some columns were hide)?
Hi!!
ReplyDeleteYou are having a very good collection of Excel tutorials. May be you want to look at my blog Mash2Blog for some computer tutorials articles.
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!
ReplyDelete