Hello-
I am trying to conduct a lookup for text value from one table to another and
receive an #VALUE! error. Here's the code:

Range("A154").Formula =
"=IF(ISNA(VLOOKUP(C114:I114,'C:\test\DIC\site\[billing.xls]billing'!$A$1:$AI$32,34,FALSE))=TRUE,,VLOOKUP(C114 :I114,'C:\test\DIC\site\[billing.xls]billing'!$A$1:$AI$32,34,FALSE))"

This works for my numeric lookups, but not the text. I even tried using the
ISTEXT and ISNOTBLANK script and it doesn't work. Is there something I am
overlooking.

Thanks-

Neecy