This is the formula:

Code:

`=IF($H$20=0,"",VLOOKUP($H$20,'Nashville Lookup Tables.xls'!NashvilleCust,6,TRUE)&", "& VLOOKUP($H$20,'Nashville Lookup Tables.xls'!NashvilleCust,7,TRUE)&" "& VLOOKUP($H$20,'Nashville Lookup Tables.xls'!NashvilleCust,8,FALSE))`

This formula throws a #VALUE error on the last statement. The referenced column in the table has zip codes in it.

I tried converting it with a TEXT statement, but either I was entering it wrong, or that is the wrong method.