not showing blanks when using lookup for entire column

Hi

How can i remove the vast amount of blanks that appear in my look up list after the selection of values?

I have ticked the "ignore blanks" but that doesnt work

I need the whole column to be looked up encase more entries are added at a later date

hope this makes sense and hope you can help again

thanks in advance

can you upload a sample worksheet?