One of the most commonly used function in Excel is the Vlookup. It is considered as a function that a user must be familiar in order for the user to be considered as power user of Excel.
Only few users may have noticed, especially those power users, that there is a difference when using Vlookup function depending on the file type of the Excel file.
One of the most noticeable difference is using Vlookup in Excel files saved as xls (Microsoft Excel 97-2003 Worksheet) and xlsx (Excel Workbook).
Using the first file type user must remember that Table_array part must be specified precisely or highlighted manually from top left to the bottom right of the database. This is the only way that Vlookup can function correctly and display the correct value based on the Col_index_num given.
On the other hand using the second file type is a lot easier when specifying the Table_array part of the Vlookup function. This can be done by highlighting the column header of the database. A simpler and faster way but having the same result with the complete process and details for the first file type.
Users should remember that highlighting the column header will not work for the firts file type.
No comments:
Post a Comment