Check multiple values between multiple excel Files

[rakaisa]

Hi,
I have somes files such as bank.xls, office1.xls,office2.xls each having a particular sheet with the following columns
Date
Payment mode
Payee
Amount
I need to check if the data from the sheet1of bank.xls has been correctly entered into sheet2 of office1.xls / sheet2 of office2.xls


eg:
31.03.2015 , RTGS, office1,50000
31.03.2015, NEFT, office1,6000
31.03.2015, RTGS,office2,50000
01.04.2015 , , office2,8979


I need to check if the first two rows have been entered into sheet2 of office1.xls
and last two rows have been entered into sheet2 of office2.xls
if data is not available i need to get a comment as to where the error is


I have data from 2008 so it is a very big file
please help

 

[jumbledore]

how about using

and(sheet1of bank'A1=sheet2 of office1'A1,sheet1of bank'b1=sheet2 of office1'b1,sheet1of bank'c1=sheet2 of office1'c1,sheet1of bank'd1=sheet2 of office1'd1)

?