Hello All. Please help with my question.

Objective: To have B column have a list of choices depending on answers gotten from column A.

I have column A with a specific set of answers on a list (data validation)

I want column B to depend on the answers of column A, and give another set of choices

I created named ranges, e.g. def (apple, mango, banana)
ghi (straberry, melon, durian)
jkl (pomelo, pear)

I selected entire column B, and selected Data Validation. I selected List, then under source, I put in "=indirect(A1)"

But this formula is not give you the choices depending on answers on column A cells. Any ideas?