Got a tricky one here. Is it possible to draw through the % number in column D on sheet 1 with the corresponding code (C1) that comes with choosing a name from the list in B1 in conjunction with the risk and objective in column C.
So for example if you select Alibaba in B1 then the first 2 accounts should read 1.89 and 1.75 respectively, the data being matched to the SEDOL code by the column headers on sheet 2. As another example if you chose Amazon.com then the first two accounts should read 1.61 and 1.49 respectively etc etc.
Many thanks in advance
Bookmarks