B bactfarmer Mar 21, 2007 #1 Can VLOOKUP return a validation list that would then look up something new?
G Gord Dibben Mar 21, 2007 #2 Probably not, but maybe you are looking for a dependent DV list based on selection from your first DV list. i.e. first list has vegetables, fruit, dogs, cats Second list has selections like beets, rutabagas, celery, carrots if you select vegetables. Or pears, apples, oranges if you select fruit. You can then VLOOKUP on those if you like. See Debra Dalgleish's site for how to set up multiple dependent DV lists. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP
Probably not, but maybe you are looking for a dependent DV list based on selection from your first DV list. i.e. first list has vegetables, fruit, dogs, cats Second list has selections like beets, rutabagas, celery, carrots if you select vegetables. Or pears, apples, oranges if you select fruit. You can then VLOOKUP on those if you like. See Debra Dalgleish's site for how to set up multiple dependent DV lists. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP
