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
