Lookup & Reference

When combining two spreadsheets, and one has truncated data, how can a pair of columns be matched for sorting. For example, one spreadsheet contains all of the investments made last year. The second contains a list for which annual reports have been completed. However, annual reports have not been completed for all of the investments. Thus, the names of investments column in the first spreadsheet contains more items, than the same column in the second spreadsheet. Since the name is a unique identifier, the goal would be to match them. Then, the first spreadsheet could be used as a checklist for those investments that still require an annual report.
Click to read the answer
Syndicate content