Define a name like

Insert =Name=Define

Name: List1

Refersto: =Indirect($A$2)

click Add button

Name: Meats
Refersto: =Sheet1!$Z$1:$Z$10 ' wherever the list is

click Add button

Name: Vegetables
Refersto: =Sheet1!$AA$1:$AA$30 ' wherever the list is

click the Add button

In data Validation dialog for Cell B2, in the list textbox put in

=List1

--
Regards,
Tom Ogilvy


"MESTRELLA29" wrote in message
...
on cell A2 = Meats

I want to put a validation list in cell B2 that goes to the Meats List,
and
if cell A2 is = vegetables to put the validation list of vegetable. is
this
posible???

Thanks for your replay