Hi Dave,

This error comes up when it does not find the required value for
VLOOKUP. Check the value of A2 in the tab July Serial Numbers.


Thanks,

Shail


Dave F wrote:
I have the following VLOOKUP formula, =VLOOKUP(A2,'July Serial
Numbers'!$A$1:$M$72,5,FALSE), which returns #N/A errors.

A2 is in a column named Asset Number, the tab July Serial Numbers has the
related serial numbers 5 columns from the left (column E). What am I doing
wrong?


--
Brevity is the soul of wit.