Hi Ruth,

It sounds like you are looking for a Vlookup type scenario...

http://www.contextures.com/xlFunctions02.html

If you select Smith in C5 you want the address for Smith to automatically show up in D5?

If so, create the lookup table and then put the Vlookup in D5 and copy down as far as required.

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