Can somebody help me with this.
I have an excel file with sheet2 that contains bill records maintained by our company and we get the same information from our supplier that we add to sheet1 , now I need to match both the bill no. and bill amount in both the sheets. If any bill no. is not there in sheet2, then in sheet3 I want that particular row pulled in. Also, if both bill numbers match then I want excel to check if the amount is the same with plus or minus 20 difference acceptable.
Sheet 1:
Bill No. | Bill Amount
12350 | 250
45856 | 300
56866 | 600
4585 | 10000
Sheet 2:
12350 | 250
45856 | 300
56866 | 550
Hoping that this problem can be solved.
Thanks
Bookmarks