Can anyone see anything wrong with this formula that would make it return an
error of N/A?

=VLOOKUP($A16,'N:\Aurora\Monthly
Report\[Templates.xls]Val'!$A$1:$G$200,4,FALSE)

Thanks, Mel