Tony,

You need to make at least 2 named ranges: List0 and List1

List0 should be a single cell, with the value n/a

List1 should be as many cells as you want for your dropdown list: enter the allowed values in that
range.

You can also have List2 and List3 if the numbers in column A are use in determining which list to
use.

Select cell B2, the choose Data / Validation. Select the Settings Tab, and select List in the
"Allow" box, and in the Source box, enter the formula

=IF(A2=0,List0,List1)

and make sure that you check the "in-cell dropdown" box.

If the numbers matter, then use a formula like in the Source box:

=IF(A2=0,List0,IF(A1=1,List1, IF(A1=2,List2,List3)))

HTH,
Bernie
MS Excel MVP


"Tony Houston" wrote in message
...
in two columns ay A & B.
In A2 there will be a number from 0-3. I want to show in B2 a dropdown list
but only if the value in A2 =0, all others should show n/a.

How can i make this work?
thanks Tony