Hi

Hoping that someone can pick this up as its something that has always annoyed me.

I have a list of names on 1 sheet with relevant details of the team they are in and on another sheet I have a list of the same names with the comments they have made to a recent survey.

What I want to do is to use a VLOOKUP function to match the comments with the group. The problem I have is that on the 1st sheet the forename and surname are together in one cell. In the other sheet the forename and surname are across 2 cells.

what I was looking around for was some kind of function that would combine the 2 together into 1 cell for use in a VLOOKUP

Really appreciate any thoughts or help