=IF(A1="","",VLOOKUP(A1,School_address_table,2,0))

where School_address_table is a table with the school's name in the leftmost
column and the address in column 2

For instance if you put all the school names in Sheet2 column A and their
respective addresses in column B it would look like

=IF(A1="","",VLOOKUP(A1,Sheet2!A:B,2,0))


Lookup VLOOKUP in help


--


Regards,


Peo Sjoblom

"Anne" wrote in message
...
Cell A1 is for school name. Used Data Validation to provide a drop down
list
to choose school name. Cell A2 is for school address. Would like a
school's
address (from a list) to be inserted when that school's name is selected
in
A1.