Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft Excel _ Multiple Results For Vlookup

Posted by: Dexter Dec 6 2017, 02:49 PM

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!!

Posted by: doctor9 Dec 6 2017, 03:44 PM

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

Posted by: Dexter Dec 6 2017, 03:56 PM

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