Making an extras casting spreadsheet in Numbers

I do extras casting for movies and was looking to make a spreadsheet for it. I have a .csv list of information (last name, first name, role, email, etc) and was looking for the spreadsheet to something kinda basic, when i type the last name in the spreadsheet that it will either automatically fill in the other blanks with the rest of the person's info or for it to have a pop-up window that would have all of the names and when i chose the one i want, then it would automatically populate the rest. I am extremely dumb when it comes to Numbers or Excel and I'm not sure how to do it...if anyone has any suggestions of a template to use or how to make one i would GREATLY appreciate it...Thanks