N/A returned on VLOOKUP formula

[Guest]

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

 

[Bob Phillips]

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)

 

[JE McGimpsey]

N/A is returned when the value in A16 is not found in the first column
of the specified list.

If you're sure the value is there, sometimes the problem stems from the
list or the lookup values having different data types - e.g., the lookup
value is Text while the list values are numeric.

 

[Guest]

Of course! I forgot the lookup has to point to the first column of the
specified range, I needed it to start in column B.
Thanks a lot, Mel

N/A is returned when the value in A16 is not found in the first column
of the specified list.

If you're sure the value is there, sometimes the problem stems from the
list or the lookup values having different data types - e.g., the lookup
value is Text while the list values are numeric.

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