How to make verification column in excel sheet

Help Studio
, ,
1

Hello i have 2 excel sheet which consist of Companies names i want to put tick mark in verification column present in excel 1 if both sheets consist of same data else a cross mark on verification column in excel 1 if data is present in excel 1 but noExcel1.xlsx (16.4 KB) Excel2.xlsx (14.0 KB) t in excel 2

2

Shift + P Gives you TickMark
Shift + O Gives you CrossMark

Crosswalkthrough the excel and write in excel as per the result