Re: VLOOKUP
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
=vlookupcity & "," & vlookupstate
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Lisa12" <Lisa12@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:697B090B-B6A5-4F2E-B478-A4CACFC34B5B@xxxxxxxxxxxxxxxx
I am trying to conect 2 VLLOKUP requests for text so they will print in the
same cell. Example City, State. How do I connect the two strings? I
have
tried using the & but have not had any success.
Thank you,
Lisa12
.
Relevant Pages
- Re: Printing merged data into 2 columns
... I can't seen to get that paragraph mark to delete. ... of the city name does not occur. ... data prints properly in each cell, the height of the cell is too tall. ... Dim source As Document, target As Document, scat As Range, tcat As ...
(microsoft.public.word.mailmerge.fields) - Re: Cell phone Coverage ???
... Companies keep making cell phones to do more stuff, ... dinner - soon) and they would become useless if the network signal is not ... not near an interstate or a big city, ...
(alt.cellular.verizon) - Re: extracting info from an address block
... What seems to happen if I edit this so that I have the formula wizard, I get an error that excel has stopped responding and then it restarts. ... city, st zip ... take 1 cell), or to paste into a cell, and then it would be 3-7 cells. ... The series of digits and or dash that follows the State. ...
(microsoft.public.excel.programming) - Re: macro to look down cells and if negative in the right of the c
... But are you sure your code kept the values strings? ... Sub movetofront() ... Set ColumnRange = Range, _ ... For Each Cell In ColumnRange ...
(microsoft.public.excel.programming) - Re: Dropdown list to return different value
... the Data/Validation "Source" box in the Excel menu. ... corresponding city "codes" are referenced. ... excel should enter "292" in its place in that cell. ... your dropdown is on Sheet1 in cell B9 ...
(microsoft.public.excel.programming) |
|
