Vlookup - Forname Surname

[wrightyrx7]

Hello all,

Im wondering if it is possible to do a vlookup to look at a table with Forename and Surname in column index 6 & 7 and return them in the same in the same cell. With a space inbetween obviously.

Thanks
Chris

 

[Joe4]

Do you want to match on both Surname and Forname or do you just want to return both Surname and Forname (matching on some other value)?

It sounds like the latter to me. If that is the case, just concatenate two VLOOKUP formulas (one returning each column index), i.e.

=VLOOKUP(...) & " " & VLOOKUP(...)

or create a new column in your lookup table which sews these two values together and return that new calculated column in your VLOOKUP, i.e.

= F2 & " " & G2

 

[HalfAce]

If I understand, you can try something like this.
If your vlookup range were: G1:H10 (G1:G10 has forenames. H1:H10 has last names.)
Your lookup cell is A1. (Where the forename gets entered.)

Now, in your formula cell somewhere you can try this:

=A1&" "&VLOOKUP(A1, G1:H10, 2)

Is that what you're looking to do?


EDIT: Oh yeah, if your lookup value is something other than the forename then go with something like Joe's suggestion. If the lookup value is the forename then what I posted should be all you need.

 

[wrightyrx7]

Thanks for the replies guys, i used the =VLOOKUP(...) & " " & VLOOKUP(...) worked like a charm.

Thank you both again

Chris