Thanks for your reply, but wouldn't that mean that the company names in columns A and B would have to line up? I don't necessarily have the same number of companies in both lists, so they wouldn't line up one to one.