Wanda

VLOOKUP with the False argument looks for an exact match and if not found
returns the NA error.

Do you believe that it should return a number?

Can you find what looks like a match in the table?

Perhaps there is a space in the cell with the correct number?


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 09:06:01 -0800, "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)