Well Olly's works, but I just tested something and the code missed it effect afterwards. I deleted a row (a name that should not longer be in the list) in the B3:B11 range.
After that, the code doesn't work anymore in B12 (B13 : B17 still works). If I delete another row, B13 doesn't work anymore.
So Olly's code is clean and simple, but should be manually changed each time I delete a row in the sheet.
I guess the code should have something with 'row()' included? I know a lot about formula's, but I am a real VBA newbie :-)
Bookmarks