Thanks for that, I've already been there!
To explain further using that site as an example
If I change cell A2 from Green Fruit to Red Fruit I would want cell B2 not
to show Lime but the list of red fruits

"Carim" wrote:

Hi,

Take a look at Debra's brilliant site :

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

HTH
Cheers
Carim