Customer needs to connect two report, as they had different data. The reports were exported to Excel.
Via Excel, you can use the VLOOKUP function to do this. To emphasise the example, we have created an Excel sheet containing two sheets.
First sheet has a table with some names and postal codes, and the second sheet has postal codes and cities. We want to get the cities by typing the postal codes in the first sheet. (this could be two reports). Essentially there should be a field that is the key and appears in both sheets. In this case it is the postal code.
Click the Fx in the toolbar to add the function:
Find the formula by clicking on the category and choose VLOOKUP:
Wou will get this picture:
In the attached sample, we entered these values in the formula:
Col_index_num = 2
Range_lookup = FALSE