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.

One thought on “COMPARE DATA LISTS USING VLOOKUP AND ISNA FUNCTIONS

  1. Muhammad Asif

    Hi Sir,

    I have data for employees vacation in different sheets. some employees are going two or three time on vacation. when I am using vlookup to make summary it is working because or repeated employees numbers. please guide me how or what formula I have to use or dsum will work for it. aslo I want to see the dates for that period in summary.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *