Vlookup function belongs to the function of searching data on Excel and we can combine functions with many other functions to process data, such as Vlookup function with If function, Vlookup function with Left function, using Vlookup function to combine 2 tables. In basic Excel functions, Vlookup function is also used frequently.
#How to use vlookup in excel 2013 to compare two sheets how to#
How to rank on Excel with RANK function. Instructions on how to separate column content in Excel. How to copy Word data to Excel keeps formatting. If done, you should combine the ISNA function, IF function and VLOOKUP function to produce more beautiful and faster filter results. The IF function will return a false condition of ‘Duplicate’.Ībove is how to use Vlookup function to search for duplicate values from multiple sheets on Excel. If VLOOKUP returns a specific value, the ISNA function will return FALSE. Where # N / A is a non-duplicate data, If will return the result No. If Vlookup function returns the # N / A error, the ISNA function will return TRUE value. ISNA function will check the value of Vlookup function. In the first box you will enter the formula below. If the function checks the condition, it returns the value you specified, if it is false, returns the b value that the user specifies.Īt Sheet 1 you enter 1 more column to compare with the Check column. If the data is # N / A, the ISNA function will return TRUE, otherwise the function will return FALSE. If so, it can be combined with ISNA function to help you check the data # N / A. In the data check column for those cells that are not duplicated, the # N / A error will be displayed. Combining Vlook function, If function, ISNA function removes # N / A error 
0 is the exact search type of Vlookup function.Ģ.
1 is the column where you want thelook function to return in the data area to be checked.Sheet2! $ C $ 2: $ E $ 11 is the same data area to check in Sheet 2.
Sheet1! C3 is cell C3 in Sheet 1, it is necessary to check the duplicate data.
0 kommentar(er)
