Prev: decap names from transferred data
Next: i want to convert decimals into time format
From: Lost in Microbiology on 11 May 2010 12:01
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?
From: Jim Thomlinson on 11 May 2010 12:09
No there is no limit. Most likely you have #Ref errors somewhere in your
source table.
--
HTH...

Jim Thomlinson


"Lost in Microbiology" wrote:

> 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?
From: Gord Dibben on 11 May 2010 12:32
A to N is 14 columns in your lookup table.

15 will certainly give an error.

Change N to O and you have 15 columns.


Gord Dibben MS Excel MVP



On Tue, 11 May 2010 09:01:01 -0700, Lost in Microbiology
<LostinMicrobiology(a)discussions.microsoft.com> wrote:

>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?

From: Jim Thomlinson on 11 May 2010 16:24
Good catch... that is more likely the error. I always use index match which
will avoid this type of issue.
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

> A to N is 14 columns in your lookup table.
>
> 15 will certainly give an error.
>
> Change N to O and you have 15 columns.
>
>
> Gord Dibben MS Excel MVP
>
>
>
> On Tue, 11 May 2010 09:01:01 -0700, Lost in Microbiology
> <LostinMicrobiology(a)discussions.microsoft.com> wrote:
>
> >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?
>
> .
>
 | 
Pages: 1
Prev: decap names from transferred data
Next: i want to convert decimals into time format