Here is my function....
=IF(ISNA(VLOOKUP($I$16,'[customers from
caselle.xls]Sheet1'!$A$2:$G$710,5&6&7,FALSE))

I am trying to join text on a row in the 5th, 6th and 7th colums of
workbook into 1 cell in another workbook, thus my guess of 5&6&7, which was
a bad guess.

Column 5 is the city, 6 is the state, and 7 is the zip code. I would like
to pull it into one cell in the following format: city, state zip.

What to I need to replace the 5&6&7 with to make this work?

Thanks,
Dan