I have been trying for several days now to grab a contact name if there is a partial match on an address. I have one sheet that will have the address (sheet1) and I want it to pull the owner contact info from second sheet if the address is contained in the address field of sheet2 into sheet1 in the 'Who?' column.
1st sheet has part of the address and the column that needs the info from sheet2:
Contact sheet (2nd sheet)
The current formula that I am using is in the 1st image.
As you can see that the property addresses will not be an exact match. I thought that maybe the unit number was messing it up but I put that in a separate column. The first part of the address will be included in Range2 in the Test Contact Sheet and there will not be an exact match.
Any and all suggestion are welcomed!
Help Article Resources
Check out the Formula Handbook template!