Varying drop down list options based on an adjacent cell

[Kirstym1918]

Hi all,

I am trying to create two separate drop down lists on one worksheet and in the same column (N). One titled 'deliveries' the other titled 'collections' both contained in cells N2:N5000 and varying each time someone pastes in to it, I want the drop down list to look at the two options (Delivery and Collection) in G2:G5000 and then allow the user to select from the relevant drop down list.

Is anyone able to help?

Many Thanks