I am trying to create 3 dependent data validation lists. Each Chain has a
dependent list of Products. Each Product has a dependent list of Displays.
Any of the lists may contain multiple word phrases. I've already looke at
the Contextures.com website and it didn't help. It only provides examples of
two word phrases.

Lists Names:

Chains CVSOdyProducts
CardStockDisplays
A B
C
1 CVS Odyssey Card Stock 4' In-Line
2 Kohls Traditional Gift Wrap Supplies 6' In-Line
3 Walgreens ACE Boxes Notes & Stationery 3' Aisle

Form:
A
Choose Chain: 1 CVS Odyssey
Choose Product: 2 Card Stock
Choose Display: 3 3' Aisle

I need the data validation formula for cells A2 and A3 on the form. Thanks!