Drop your workbook below. We'll resolve every company name to its CapIQ
identifier, inject a hyperlink directly onto the cell, and hand you back
the enriched file.
Source
CapIQ → Company Screening Report → Export to Excel
Structure
Sheet named Screening — company in column A, ticker in column B
Output
Same workbook, with cell-level hyperlinks on every matched name