How to compare two excel data


#1

Hi i have two excel sheet i am comparing Technology to column1 ,Experience in Months to column2, Proficiency to column3, skills to column4

SHEET1

Column-1 Column-2 Column-3 Column-4

Core Java 6 Intermediate Primary
JSF 2 Beginner Primary
Servlets 2.x 6 Intermediate Primary
JSP 6 Beginner Primary
JDBC 6 Beginner Primary
Jquery 6 Intermediate Primary
Core Spring 6 Intermediate Primary
Angular JS 6 Beginner Primary
Hibernate 6 Intermediate Primary
iBatis 2 Beginner Primary
Javascript 6 Intermediate Primary
SQL 6 Intermediate Primary
AJAX 6 Beginner Primary
HTML 10 Intermediate Primary
HTML5 6 Beginner Primary
CSS 10 Intermediate Primary

sheet2

Technology Experiecde in Months Proficiency Skill Type
Core Java 6 Intermediate Primary
IOT 4 Beginner Primary
HTML 10 Intermediate Primary

expected output

width=“690” height=“388”>Column-1 Column-2 Column-3 Column-4 Status
Coloumn1 column2 column3 column4 status
Core Java 6 Intermediate Primary Match
JSF 2 Beginner Primary Unmatch
Servlets 2.x 6 Intermediate Primary Unmatch
JSP 6 Beginner Primary Unmatch
JDBC 6 Beginner Primary Unmatch
Jquery 6 Intermediate Primary Unmatch
Core Spring 6 Intermediate Primary Unmatch
Angular JS 6 Beginner Primary Unmatch
Hibernate 6 Intermediate Primary Unmatch
iBatis 2 Beginner Primary Unmatch
Javascript 6 Intermediate Primary Unmatch
SQL 6 Intermediate Primary Unmatch
AJAX 6 Beginner Primary Unmatch
HTML 10 Intermediate Primary Match
HTML5 6 Beginner Primary Unmatch
CSS 10 Intermediate Primary Unmatch


How to compare a row in excel with a column in another excel?