Field Lookup List to a Slice based on User Input

Hi there,
I have two slices for jobs either in CA or NonCA (both exist in one sheet with Location displaying the CA or NonCA values for each record)…When the user selects CA or NonCA in a field, I would like the next field to show the appropriate slice…hopefully that makes sense and any help is appreciated. TIA!

0 8 750
8 REPLIES 8
Top Labels in this Space