Hello, I have sheet1 that contains names and addresses. On sheet2 I made a
drop down box to choose any of those names. Is it possible to have the
correct address fill in automatically in the cell next to the one the name is
in ? Thanks for any help, -Kevin