Tenspeed39355
05-13-2008, 06:32 AM
Good morning guys. I do not know how to start this out so this is the best I can do to explain what I am trying to do.
I have a chart in Excel Sheet1. In sheet2 is a data base. I am using VLookup to bring over the Symbol and the data to put into the chart in
Sheet1. So far no problems. The symbol I am bringing over is the Mkt Symbol, Example: ACG. This is where I am at a loss. ACG has another symbol that represents the Net Asset Value of the fund. The symbol is
XACGX. When I type ACG in cell A1 the data from Sheet2 goes in the chart. How can I put the Net Asset Value SYMBOL in A2 when I type in the Mkt symbol ACG in Cell A1?? I have over 650 symbols in the data base
that have Nav Symbols. I have used Concatenate to change the Mkt symbol from ACG to XACGX I just do not know how to get the Nav symbol XACGX in Cell A2. Thanks for any help on this one
Max
I have a chart in Excel Sheet1. In sheet2 is a data base. I am using VLookup to bring over the Symbol and the data to put into the chart in
Sheet1. So far no problems. The symbol I am bringing over is the Mkt Symbol, Example: ACG. This is where I am at a loss. ACG has another symbol that represents the Net Asset Value of the fund. The symbol is
XACGX. When I type ACG in cell A1 the data from Sheet2 goes in the chart. How can I put the Net Asset Value SYMBOL in A2 when I type in the Mkt symbol ACG in Cell A1?? I have over 650 symbols in the data base
that have Nav Symbols. I have used Concatenate to change the Mkt symbol from ACG to XACGX I just do not know how to get the Nav symbol XACGX in Cell A2. Thanks for any help on this one
Max