nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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!

Find more posts tagged with

Sheets

Formulas

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

IF, CONTAINS, NETDAYS, AND, CONTAINS
Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…
How to automatically populate Assigned To across multiple lines
Hi all, I a very new to Smartsheet (4 weeks) and this community so my apologies if my question doesn't match the rules. I have built a PMO template and profile which I will integrate with control centre to automatically generate a new project triggered by HubSpot. The template has a set of activities across multiple…
Set up Metrics
Hello, I am having a hard time figuring this out. I am new to smartsheet. I want to create this metrics table but I don't know how to create the reference formula!! Please help!