Adding a space between 2 vlookup functions

FlyerTalks

Hi All,

 

How can you add a space between 2 vlookup functions?

Here's the formula: =VLOOKUP(Alias247, {Pilot Data Base Range 4}, 3, false) + VLOOKUP(Alias247, {Pilot Data Base Range 4}, 2, false)

This will show First_NameLast_Name.

Thanks!

 

Mike Wilday

Try this: 

=VLOOKUP(Alias247, {Pilot Data Base Range 4}, 3, false) + " " + VLOOKUP(Alias247, {Pilot Data Base Range 4}, 2, false)

FlyerTalks

That works! Thank you!

Mike Wilday

You're welcome. Glad I could help out.