This requires IMMEDIATE ATTENTION. I have 1 hour to get this done!
I have 2 databases.
Database 1 (6000 entries) is an old database with teachers details, addresses, telephone, school address etc.
Database 2 (30,000 entries) is a new database of postal codes and a corresponding unique ID.
I need Database 1 to show the unique ID of the school that corresponds to the teacher by checking the entry in post code and comparing it to the unique post codes on Database 2. If it matches a postcode on Database 2 then in a new column on the correct row, it will show the UNIQUE ID from database 2
If there is no match it should say NO MATCH
If there is more than one match it should say DUPLICATES