Is a there a lookup formula I can use to match data from multiple columns of data?

Unfortunately because of the development I need to do further down the line, that option will not work as I need to be able to concatenate the data in work sheet 2 later on.