Matching

Matching


We have a database in Reports which contains monthly data for investments each of which has a unique identifier. This data is classified into different sectors, which we then analyse within Reports. We want to be able to reclassify this data using external data which would identify matches between our Zoho Reports database and the external data using the unique identifier - if there is a match of the unique identifiers then a new column would be created with the new classification. Could you let me know if this is possible and if so how I set it up. 

Thanks in advance.