Formula to match Column E from Renewals tab with Column A in Addresses Tab.
When match is found copy columns B to F from Addresses Tab to empty columns to the right in Renewals Tab.
File is attached with the 2 tabs discussed here.
Thank you!
... Show more