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.