You can use something like this (based on your other lookup post):

Assume CITY is in column 2 of "database" and STATE is in column 3 of
"database".

=IF(ISNUMBER(MATCH(B2,INDEX(database,,1),0)),
VLOOKUP(B2,database,2,0)&", "&
VLOOKUP(B2,database,3,0),"")

This will return in the same cell:

City, State

Biff

"Confused" wrote in message
...
Is it possible to have two vlookups in one cell? I am have a datasheet
where
the city and state are in two columns. In another worksheet is a specific
template where if I input the employee name, the template would
automatically
populate the data related to that employee. The problem is, in the
template,
the city and state are shown in the same cell. Not sure if vlookup can do
this.

please help. Thanks.