Is there a way to merge two spreadsheets using an If/Then formula. For example, I have two spreadsheets. One spreadsheet has the city listed. The other has the address. Is there a formula that will merge the two? If "Bakersfield" then use the "Bakersfield address"?