Match Problem


compared the column from one sheet to another sheet

Sheet1: ID

Sheet2 : EmpID

i can able to Match all the data which is under ID column to EmpID but if the ID Starts with 0 its not comparing. EX(0123)

I used this formula

=IF(COUNTIF({check1 Range 1}, EmpID@row) > 0, 1, 0)