Hello Everyone,
I am hoping someone may be able to help me out. I have a list of building addresses and unique building numbers generated from our system. I have another list of opportunities generated from the same system that contain two building numbers for each opportunity. Each opportunity has its own unique opportunity number. I need to lookup the building number from list one and receive a return of all opportunity numbers that contain that building number. I am at a loss and everything I try does not work. Any help or guidance is greatly appreciated. Thank you in advance.
I am hoping someone may be able to help me out. I have a list of building addresses and unique building numbers generated from our system. I have another list of opportunities generated from the same system that contain two building numbers for each opportunity. Each opportunity has its own unique opportunity number. I need to lookup the building number from list one and receive a return of all opportunity numbers that contain that building number. I am at a loss and everything I try does not work. Any help or guidance is greatly appreciated. Thank you in advance.