Lookup to fill droplists

[Bananonymous]

Hi There,

I'm kinda new here and need help with a Excel i've been stuck on for a while, hope someone can help.
So, Say I have a Sheet1, on which there is a list that you have to fill (Things) I would like for the cell next to it to be a droplist according to what's next to this cell on Sheet2, if that's possible ?
Hope that was understandable, please let me know if not.

Here is an example I tried to remake as my data cannot be shared.

Thanks in advance for any help

BR

[José Augusto]

Hi

Select F15 in Sheet1. Use the following formula in data validation list

Please Login or Register  to view this content.

Drag down the validation List
Note: No choice is permited if E15 is not on Sheet2!B6:B9

See the file

[Bananonymous]

Wow, That's exactly what I needed, Thanks a lot for the quick help !! :D