Forum Discussion
Indirect reference
Hello I have an excel file where I am using for some cells an indirect reference to validate the content of the cell
I have table 1 where the I have two columns classification level 1 and classification Level 2. Classification level 2 changes depending on classification level 1. for this I used indirect reference to be able to show a list on classification level 2 depending on classification level 1.
I used in data validation the following formula : =INDIRECT(Reference_Indirecte!$A2) for the second line and so on
my problem is that whenver I deleted line in the table 1 the references doesn not change and continue to be the intial line
can you please support.
regards,
Imbrg
Here is the file.
10 Replies
Hello,
it's a bit difficult to picture what the issue is and what you want to achieve. Could you upload a samle file and explain in context?
Dear
I am using the Excel file where you will find the link below.
the field classification Level 2 is changing based on the content of classification level 1 and same thing for Market sub segment which content will change based on market segment.
to realise this I am using data validation and list. the list referefs to another sheet and indirect reference.
This is working fine except when i delete a line in accounts worksheet, the reference to the right line is not working anymore.
exemple : classification Level 2 in line 6 is : =INDIRECT(Reference_Indirecte!$A6)
if I delete this line (6) then the classification Level 2 in this line is : =INDIRECT(Reference_Indirecte!$A7)
while it should have been modified
please support me on this issue.
https://schneiderelectric-my.sharepoint.com/personal/sesa353194_schneider-electric_com/_layouts/15/guestaccess.aspx?docid=19f7368569eb24eeeaa7f4b2a3b3f2a67&authkey=AUquMHxiMXg9Vpao1-QwB8s&expiration=2017-07-13T23%3a00%3a00.000Z
Hello,
that link opens the Excel file in Excel online. In order to help I need a file that I can download and open with desktop Excel. Data validation cannot be created or changed in Excel online.
