View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WandaSG
 
Posts: n/a
Default VLookup N/A Error

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