Excel Formula Problems

[Sleek]

Hello,
Please I have been trying to crack this for a few days now and I would really like some help. The problem goes like this:
I have two excel documents, Doc A and Doc B. Doc A contains two sheets, While Doc B contains one sheet.The information in the two sheets of doc a is pulled together in the one sheet of doc b. this two documents have different columns like Staff Id no and staff name and staff net pay. basically, am to create a third excel workbook that is totally automated and compares the information in doc a to the one in doc b. E.g if JUM001 is paid 5000 in doc b, this new workbook is to check that JUM001 in both sheets of doc A is paid 5000. If in doc a, JUM001 is paid something different, it is to return an error message. Hope you guys can help me crack this. Thanks.

 

[cyrilbrd]

Hi, why don't you use something around =IF(INDEX([Doc A.xlsx]Sheet1!range1,MATCH(A2,[Doc A.xlsx]Sheet1!range2,0))=INDEX([Doc B.xlsx]Sheet1!range1,MATCH(A2,[Doc B.xlsx]Sheet1!range2,0)),"","error")