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    
post Dec 6 2017, 02:49 PM

Posts: 696
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.:


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    21st October 2018 - 05:32 AM