View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lost in Microbiology Lost in Microbiology is offline
external usenet poster
 
Posts: 49
Default VLOOKUP #REF error

I have a vlookup that works for the first 14, columns I want to reference.
But when I get to the 15th column I get the #REF error.

This is the formula:
=VLOOKUP($A2,$A$1100:$N$7704,14,FALSE)

Is there a limit on the number of columns a VLOOKUP array can have?