UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Multiple Results For Vlookup, Office 2013    
 
   
Dexter
post Dec 6 2017, 02:49 PM
Post#1



Posts: 625
Joined: 5-November 07



I currently have a vlookup statement in a cell that works as long as I only need one result.

This formula copies over the street address, based on the selection in D54 of sheet named Engagement.:

CODE
=VLOOKUP(Engagement!D54,CompanyList2,3)


What I need is the "3" above then a space and then "4" then a comma and a space and then "5", and then another space and "6", with 4, 5 and 6 being the city, state and zip.

So, my result will be 123 Any Street Somewhereville, TX 12345

Can this be done? If so, how? I am confused by what I read online researching this... I am new the arrays.

Thank you!!
Go to the top of the page
 
doctor9
post Dec 6 2017, 03:44 PM
Post#2


UtterAccess Editor
Posts: 17,926
Joined: 29-March 05
From: Wisconsin


Dexter,

Have you tried this?

CODE
=VLOOKUP(Engagement!D54,CompanyList2,3) & " " & VLOOKUP(Engagement!D54,CompanyList2,4) & ", " & VLOOKUP(Engagement!D54,CompanyList2,5) & " " & VLOOKUP(Engagement!D54,CompanyList2,6)


Hope this helps,

Dennis

--------------------
(;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it.
Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
Go to the top of the page
 
Dexter
post Dec 6 2017, 03:56 PM
Post#3



Posts: 625
Joined: 5-November 07



Yes but I think I copied the = multiple times so it was giving me an error... It's working now. Thanks!
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 03:23 PM