Wanda,

Find an example where this happens and check to see if you have trailing
spaces in one of the entries, etc.



"WandaSG" wrote:

We have the following formula that returns a numerical result for some, but
#N/A for others. Why an error and not a number?

=VLOOKUP(A8,'Highmark run'!$A$5:$Y$1821,23,FALSE)

--
Wanda Garner
Highmark Blue Shield