View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Anne is offline
external usenet poster
 
Posts: 74
Default 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.