Welcome!

Adding a space between 2 vlookup functions

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!

Sheets

Formulas

Try this:

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

That works! Thank you!

You're welcome. Glad I could help out.

Created Date by column to show on line entries only
Hi How do i set created Date column to only show entries from line 24 downwards?
Help on getting the SHIFT from a time
Hi, I m trying to extract the shift where and inspection is conducted. primary time source is CREATED DATE column, than I extracted the time using the formula " =TIME(RIGHT([Inspection Date]@row, 8))" however I can't figure the approach to get to the Shift if I am hoping a return of 1, 2 or 3 from: Shift 1 = 0600 - 1359…
Formula check: select drop down option based on other columns
Hi everyone, I'm looking to use a formula that will select one of my drop-down statuses (Rejected) IF the Avg Score is below 50% OR one of the other columns has the selection of "Red Flag (quality/ethical/concern: cursing, condescension, etc)." Otherwise, I want the field to populate the other status (Acceptable). I'm…