I have a list of values and subvalues on a worksheet called DataValues and am
trying to use the INDIRECT function for Data Validation as documented at
http://www.contextures.com/xlDataVal02.html.

I'm trying to create one column on an entry sheet that allows you to select
from List A, then, in the adjacent cell, select a corresponding entry from
List B - the data in List B (Column 2) is dependent upon what was selected in
List A (column 1).

The example at this site shows List A with a choice of either Fruit or
Vegetable, then List B (Fruit List) and List C (Vegetable List) contain
corresponding entries.

I think I have everything defined, but when I get to the point where I
actually try to use the INDIRECT function to validate data in my second
column, I cannot get the correct formula. If I try to enter the worksheet
name and reference, I get an error and cannot get this secondary/dependent
list to populate correctly.

I'd appreciate any help!