I need to have what I think is an if then forumula so that when x is placed in a cell in column C then y will automatically be place in column D in the corresponding cell.



So, if Smith is put in C5, then 123 is put into D5. Originally I made a dropdown list for Column C with Names and then for Column D with addresses, and that does work, of course, but it would less drop downs if I can just have a list in C that will populate the corresponding cell in D with the correct address when a name is chosen from the list. So I thought it would be a kind of if then statement, but I have no idea how to create anything like that. Thanks for any help.

Ruth