VLOOKUP

[Lisa12]

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

 

[Pete_UK]

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

 

[Don Guillett]

=vlookupcity & "," & vlookupstate

 

[Dave]

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