Answered By: Andrea Schulman
Last Updated: May 20, 2015     Views: 3908

Download the Thomson ONE  Excel Add-in, if you haven't already done so.

In Excel, use the Item Lookup from the Thomson ONE  menu tab.

You will get a menu as follows:

Make your selections for the Company, Period, Value, and Layout And Caption.  Then double click on the item you want where the results of the search are displayed.  The values and caption will then be inserted into the cells in your spreadsheet.