Yes, either a1 can't be found in A1:A200, or the value in column D of that
row is itself #N/A.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Meltad" wrote in message
...
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