Concatenate a VLOOKUP
Hi All,
How can I concatenate a VLOOKUP from 3 cells showing city, state & zip into one cell? Thanks in advance |
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 |
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 |
All times are GMT +1. The time now is 02:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com