Sign in to join the conversation:
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!
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.
Hello! I have been using Smartsheet for a few years but have really only used the basics. I have a form for our branch managers to submit their monthly safety checklists and wanted to see if there was a way to track / indicate which locations did not submit and for which months. On the form, there is a drop down for them…
I am getting an #Unparseable error on the following formula My time is already in military time. I am trying to get hours worked.
Hi, I have a 2 tracker sheets, they both have columns for 12 periods, P1, P2 etc., rather than the names of the months as they can start at any time and run for 12 months. First tracker sheet - The start date for the tracker can be, the first day of any month. Second tracker sheet - The start date can be any day of the…
