# Excel Formula Problems

#### Sleek

##### New Member
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.

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### cyrilbrd

##### Well-known Member
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")

Replies
2
Views
409
Replies
2
Views
1K
Replies
5
Views
623
Replies
1
Views
515
Replies
1
Views
516

1,195,853
Messages
6,011,967
Members
441,658
Latest member
Carlos O

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back