This formula works for some reason but I don't understand how. I tried to follow it by separating the functions but still don't understand.
Vlookup(lookup value (company name), table array (where to look), col_index_num (which column to look in), [range lookup] (always 0)) gives value that matches conditions
Match(lookup_value (CapIQ chart title),lookup_array (where to look), [match type] (exact)) gives item number in a list
Index(array (the table), row_num, [column num]) returns the value in the cell