Thank you for your help! I sort of got it to work, but I can't find out how to have it not put a #NA in a cell that is empty. The only way I could figure out how to do it, was to remove the vlookup from any empty cell, but that means having to put it back if I end up with a name in the cell. Isn't there a way to include cells that if they are blank nothing gets put in the corresponding one?

Ruth