Hello there,

I hope someone could point me in the right direction:

I have my table something like this:


Contract Subcontract ID SPID
21673000 21673000-7 49 1,231
11873001 11873001-18 48 1,232
11873001 11873001-17 47 1,232
11873001 11873001-16 46 1,232
11873001 11873001-15 45 1,232
11873001 11873001-14 44 1,232
11873001 11873001-13 43 1,232
11873001 11873001-12 42 1,232
11873001 11873001-11 41 1,232
21673000 21673000-6 40 1,231
21673000 21673000-5 39 1,231
21673000 21673000-4 38 1,231
21673000 21673000-3 37 1,231
11873001 11873001-10 36 1,232
11873001 11873001-9 35 1,232
11873001 11873001-8 34 1,232
11873001 11873001-7 33 1,232
11873001 11873001-6 32 1,232
11873001 11873001-5 31 1,232
11873001 11873001-4 30 1,232
11873001 11873001-3 29 1,232
11873001 11873001-2 28 1,232
21673000 21673000-2 27 1,231
11873001 11873001-1 26 1,232
21673000 21673000-1 25 1,231


and in other sheet I would like to have a field where the user type the contract number and below a data validation shows a drop down with all of the "Subcontracts" that matches the contract.

Is this possible?

Or maybe have the Contract field to autocomplete to speed up the typing process also?



Contract 11873001

Subcontract 11873001-18 Drop down values from 01-01 to 01-18



Thanks in advance for any response