COMPARE DATA LISTS USING VLOOKUP AND ISNA FUNCTIONS

You can not only use Vlookup to search for data in large Microsoft Excel worksheets but you can combine Vlookup with other functions like ‘IF’ and ‘ISNA’ to compare lists of data. Of course you can use the powerful macros (VBA) to compare and highlight data in different lists to find out whether any data in the lists is different. Such comparison of lists is a routine and important tasks in companies like those that provide courier services.