Circular Reference Errors

[aeddipa]

I'll post an attachment so you guys can understand the situation a little better. Basically, I would like to reference the Tickers to give me the results for the Sub-Port-ID's. However, the Tickers already references the Sub-Port-ID's so this will not work.

The purpose of this is so that the Sub-Port-IDs will change when I switch portfolios. (You can't see that from the example as I am not submitting the true file). Once I link the Sub-Port-ID to the table at the top left, I will be able to match up the correct values when switching between my 11 different portfolios.

Thanks in advance if anyone can help.

[contaminated]

I didin't see posted book but try Tools>Options>Calculations and mark Iterations
Hop it helps...