Assuming Names n Addresses are listed in Sheet1's cols A and B
In Sheet2,
Assuming the DV to select the name is in A1 down
In B1, copied down: =IF(A1="","",VLOOKUP(A1,Sheet1!A:B,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kevin" wrote:
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