I am using a formula to lookup address information and paste it into a sheet, and need help fixing an error.
This is the formula:
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.
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.