Insert a specific address from a list if the contents of cell A1=x
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.
|