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

You would have something like:

=VLOOKUP( ... ) &", " & VLOOKUP( ... )

where the only difference in the vlookups is the column in the lookup
table where you expect to get the data from.

Hope this helps.

Pete


On Jun 23, 2:55*pm, Lisa12 wrote:
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

=vlookupcity & "," & vlookupstate

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lisa12" wrote in message
...
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

Hi,
=Vlookup(A1, A3:C10,2,0)&" "&Vlookup(A1,A3:C10,3,0)
This works for me.
Regards - Dave.