I am getting a #N/A when I try to use a variable to represent a table array.
The table array incluses a network path. It looks like this:

=IF(ISNA(VLOOKUP(A29,'S:\CLIENTS\P\Tracking\2005_T racking\Daily\[Through
7-13-05.xls]how_ordered'!$A:$F,6,FALSE)),0,VLOOKUP(A29,'S:\CLI ENTS\P\Tracking\2005_Tracking\Daily\[Through 7-13-05.xls]how_ordered'!$A:$F,6,FALSE))

This formula does work on it's own. What I am trying to do is be able to
change the date automatically. First, I have a row with all the date in a
m-d-yy format. I then use the TEXT function on the date. Next I use
SUBSTITUTE to change 7-14-05 to 7-14-05. This resides in cell U9. When I
use VLOOKUP(A29,U9,6,FALSE) or when I use VLOOKUP(A29,INDIRECT("U9"),6,FALSE)
I receive a #N/A error. If I remove the " " from the idirect statement, I
get a #REF error. I need to be able to increment the U9 when I copy
horizontally ( i.e. V9, W9, X9,...) Any help would be appreciated.