Find Replace Advance Help Different Tenants Same Name

[sslattery17]

I know how and understand the use of the Find and Replace tool; (v-lookup).  The issue I am having is when I have more than one property with the same tenant name the data fills with one or others Lease Expiration and Lease Start dates which are the two fields from the res direct file I want to add to the detailed rent roll file.  If anyone has any suggestions, guidance or solution that would be greatly appreciated.  I have attached the dataset and the screen shots showing the before data from the two properties and the pulled data with dates from one tenant showing on both tenants (Units 902 and 6203) different communities.

Shannon 

[chukleswk · Accepted solution]

I don't recommend using a Find and Replace in this instance as you have a tenant that can have many units rented and the Find and Replace really works if you have one dataset with a unique key field. In this instance, I would use a Join and I would join the data on the Resident and Unit fields. This will ensure that you are only getting the information for that resident / unit. If you are wanting to use a Find and Replace, you will need to create a unique key field in each of your datasets. This can be done by using the formula tool, creating a new field called "Key' and then joining together Resident and Unit fields. This will ensure that the Resident and Unit from one dataset gets matched to the correct data in the 2nd dataset.

[Qiu]

@sslattery17 
Second with approach from @chukleswk 

[sslattery17]

@chukleswk and @Qiu Thank you.