The simple explanation is most of these are Excel VLOOKUPs gone wrong.