View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 2
Default Checking numbers across various sheets

Hi
Im trying to chk numbers if they match between sheets. I have 7
sheets in the workbook. Is there a way to put the statement below
from sheet1..sheet7?

This formula would be on sheet8 where the person would enter the
number again to confirm its correct!
=IF(NOT(Sheet1!$A1=Sheet1!$B1),"numbers do not match","")

Thanks
Mike