If there is no exact match for A8 in the target range (W5:W1821 in this
case), #N/A is returned.

--
Ian
--
"WandaSG" wrote in message
...
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