View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default 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"