This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to do a multi tiered data validation function and only some of the data is coming across. My 1st column has the correct data. The second column is reading correctly from the 1st but when I go to get the 3rd column to read from the 2nd that is where I am running into problems. can anyone help?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
This link on my site may help - http://www.ashishmathur.com/secondary-validation-cell-entry-to-update-when-primary-validation-cell-changes/
Hello,
this is a bit hard to troubleshoot without more information about the technique you are using for dependent data validation.
We'd really need to see the file with some sample data and the formulas that you are using.
Here is an excellent tutorial on dependent data validation with two layers. It can be extended to more.
| http://www.contextures.com/xlDataVal02.html |
|---|