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
