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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> 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
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 01:54 AM