Difference of Vlookup Function based on File Type

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.

Applying Filter to Check a Shared Worksheet

A worksheet that was being accessed and updated by different users, especially of different departments or teams, may contain some differences in format like letter case of the words, font and size. Working in a worksheet of this kind should be done with a lot of caution as there are some functions in Excel that has some limitations or effects to the worksheet that some users may not notice.