Concatenate a VLOOKUP
OMG, I got too comlicated & overlooked the obvious.
Thanks for showing me the light.
On Wed, 27 Aug 2008 12:46:15 -0700, Duke Carey
wrote:
You want to VLOOKUP to return 3 different values and then concatenate them,
right? Far simpler to add a new column to your VLOOKUP table that
concatenates the City, state, & address, and then return THAT value in a
single VLOOKUP function
"lehigh46" wrote:
Hi All,
How can I concatenate a VLOOKUP from 3 cells showing city, state & zip
into one cell?
Thanks in advance
|