IF Then Statements for comparison
Hello, i want to make a function for comparing two excel file.
If A2(xls1) is found in ColumnB(xls2)
then check if B2(xls1) is equal to ColumnB(xls2) cell Result
If equal then input "ok" in E2(xls1)
if not equal the input "wrong" in E2(xls1)
Else "Not Found"
|