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.
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
