N/A returned on VLOOKUP formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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.
 
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 said:
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.



Meltad said:
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
Click to expand...
Click to expand...
 
Back
Top