I have a basic spreadsheet and I am trying to use a data validation
with a source of a list of customers, and then use data validation with
a source that is driven from the choice made by the first validation.

eg. col A choose customer
    col B choose from a list of jobs for the customer selected in col a

My problem is setting the source code for the second validation.
If/then formulas require too many nests and references to cells imput
that cells contents and not the renge of information that I want.