I'm sure there is a way, but without actually seeing a sample of how the data is structured, and what you would actually like to see as a result, it's very hard to give you a precise answer, INDEX/MATCH seems a natural, but it would depend on how the data is set up...