VLOOKUP in Validation? 1

[DD999]

I'm trying to build a dynamic list that functions as follows.

A normal list with the numbers 1 through 6 enters a value into column A.

Another list in column B needs to look at the value in column A to be able to present a subset of options that only purtain to the value in A.

The various combinations of A and B values are stored in a table in another sheet in the same workbook.

I've tried using VLOOKUP with data validation but can't get it to work. Is there a better way?

Thanks

 

[SkipVought]

Hi,

Check out

http://www.contextures.com/xlDataVal02.html

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[DD999]

Awesome! That's just what I needed.

So I'm giving you a star for pointing me in the right direction.

Thanks a ton!