Data validation source from two lists

[scoha]

How can I change the source list for a data validation based on the assessment of a particular controllilng cell?

I have a cell that shows either; "Handicap" or 'Scratch" which is set by other processes in my worksheet.

The first column in my worksheet consists of Data Validation cells which select items from lists relevant to Handicap or Scratch

What I need is if the controlling cell is "Handicap" then the DV is driven by the Handicap DV list and if its "Scratch", the same DV is driven by the Scratch list.

Can anyone please help me with this?

Happy to use VBA if necessary but would love an example of right code

cheers

 

[Sal Paradise]

If your lists are named "Handicap" and "Scratch" and the picker is in cell A1, then in the data validation write:
=INDIRECT(A1)

 

[mikerickson]

Another validation list source formula could be
=IF(A1="Handicap", $B$1:$B$10, IF(A1="Scratch", $B$11:$B$20, $C1:$C3))