Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a VLOOKUP
Hi All,
How can I concatenate a VLOOKUP from 3 cells showing city, state & zip into one cell? Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a VLOOKUP
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE & VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup & Concatenate? | Excel Discussion (Misc queries) | |||
Vlookup, Concatenate, Format | Excel Discussion (Misc queries) | |||
Concatenate and Vlookup | Excel Worksheet Functions | |||
Can you use Concatenate with the If function with vlookup in the i | Excel Worksheet Functions |