Pull data using drop-down list (URGENT - ATTACHED)

sample.xlsx

See attached.

I have completed the drop-down list. I need the option selected to pull all the jobs that have that parish from the Works Record tab.

Thought this would be easy but my vlookups aren't making unique, neat lists. Just lots of gaps and N/As.

Needs to be a unique list without duplicates.

Any help would be a god send. In a massive hurry!

Thanks

Hi Kl2x07,

welcome to the forum.

Try using below formula:-

Formula:

Please Login or Register  to view this content.

enter this with key combination: ctrl shift enter

see attachment:- sample(2).xlsx


Regards,
DILIPandey
<click on below * if this helps>

You are welcome...


please mark this thread as [SOLVED]... thanks.

Regards,
DILIPandey
<click on below * if this helps>