I need to create a formula that will go to another workbook and based on
criteria from the original workbook (matching address) return the sales
associate for that address. If the address is not found I will need the cell
to state "GSI". Similarly I need to do this for the Property Manager column
as well using the same criteria.