Column B3:B50 is reserved for a First Name
Column C3:C50 is reserved for a Last Name
Column D3:D50 is reserved for a concatenation of the two via the equation below...

=IF(OR(B3<>"",C3<>""),CONCATENATE(B3," ",C3),"")

Then i selected D3:D50 and selected Insert > Name > Define > List to generate a list for a pop-up menu.

So, why does my pop-up menu have "Nil" for every cell (D3:D50) that doesn't have a value? I don't want to put a blank space in there or I'll have a pop-up with a bunch of blank entries to select. Ideas? Is this not the best way to accomplish this?