An Indexed Resolution
As a final resort, there is always the indexed solution. In the indexed solution, the data from one spreadsheet is collected. The data is then aligned with data from the second spreadsheet. Then an index is created that allows a cross reference to be made between data in the spreadsheets.
It takes a lot of work to create an indexed solution. Tying the elements of data together is usually not an easy thing to do. But an indexed solution is always a possibility, in the worst of cases.
