I'm trying to do a couple of very simple tasks in Excel: 1. retrieve a RIC based on ISIN and 2. retrieve GICS industry group based on the RIC (I'm not even sure if there is a way to retrieve the industry group from ISIN).
Currently, I would first use Build Formula to grab RICs. An example of formula looked like =TR($L$12,"TR.RIC","CH=Fd RH=IN",M13. Then I would manually type in =TR($L$12,"TR.GICSIndustryGroup") in a different cell using the cell reference. However, I don't know how to apply this last formula to other cells. So if there's a list of RICs in A1:A25, then I want to populate the GICS industry group for each of the RIC. I can't seem to drag the formula down so the cell reference dynamically applies to the next cell while keeping the formula, so I've been manually typing the same formula while only changing the cell reference.
If you could walk me through like I'm five, that would be amazing. I'm very new to this.
