identify unmatched data

[#1]

hi all,

how to find unmatched data identifying in two excel sheets?

[ramasaisaksoft]

There is vLookup() function in Excel it will help to you for comparison any type of data in 2 columns..

syntax of is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/

or else if you share both the excel sheets with small amount of sample data we will help to you

if you got the the solution,Please close the thread by clicking correct Answer