I'm trying to combine a "Vendor" summary sheet and a "Customer" summary sheet. The problem is some companies are on both lists and hence there are times when there is only one entry to move to the "Combined" list, and other times when there are two entries that need to be added and then moved to the list.
This the unsuccessful formula I have so far in cell C6:
Formula:Please Login or Register to view this content.
Here's a screen grab of the sheet:
Combine Data.jpg
Here's a reduced version of the file (look under "Pallets - Year" tab):
Bookmarks