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

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

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.



In article ,
Meltad wrote:

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

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



"JE McGimpsey" wrote:

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.



In article ,
Meltad wrote:

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