Automatic reference number for multiple ranges

Hi there,   I am currently putting a sheet together and I need to generate automatic reference numbers that are linked to particular companies. So when you type in your company, I need it to find t...