Hey!

My supervisor has asked me to create multiple reports using a streamlined method in excel. This would involve pulling data from a source CSV and placing it in the respective reports using as little formatting as possible. The only information to reference the information I need for the report is the ID number which has 16 digits with the first 9 identifying the individual institution.

In short, the function must match the first 9 digits and return multiple rows of data in full.


ExcelEg.png