Adding multiple vlookups

[John K]

I want to add 5 multiple vlookups together. Here's what I got:

=if(iserror(VLOOKUP(A2,ydt,2,false)),0,VLOOKUP(A2,ydt,2,false)+iserror(VLOOKUP(A2,wk1t,2,false)),0,VLOOKUP(A2,wk1t,2,false)+iserror(VLOOKUP(A2,wk2t,2,false)),0,VLOOKUP(A2,wk2t,2,false)+iserror(VLOOKUP(A2,wk3t,2,false)),0,VLOOKUP(A2,wk3t,2,false)+iserror(Vlookup(a2,wk4t,2,false)),0,vlookup(a2,wk4t,2,false)

But I keep getting an error message and it looks at the 2nd ,0, in the
formula.

[Kevin Vaughn]

It appears you have mismatched parenthesis. With your formula in b1,
=LEN(B1)-LEN(SUBSTITUTE(B1,"(","")) returns 16 and
=LEN(B1)-LEN(SUBSTITUTE(B1,")","")) returns 15. It looks like that missing
right parenthesis probably goes at the very end. I can't tell if there are
other errors, but this should get you started.
--
Kevin Vaughn


"John K" wrote:

> I want to add 5 multiple vlookups together. Here's what I got:
>
> =if(iserror(VLOOKUP(A2,ydt,2,false)),0,VLOOKUP(A2,ydt,2,false)+iserror(VLOOKUP(A2,wk1t,2,false)),0,VLOOKUP(A2,wk1t,2,false)+iserror(VLOOKUP(A2,wk2t,2,false)),0,VLOOKUP(A2,wk2t,2,false)+iserror(VLOOKUP(A2,wk3t,2,false)),0,VLOOKUP(A2,wk3t,2,false)+iserror(Vlookup(a2,wk4t,2,false)),0,vlookup(a2,wk4t,2,false)
>
> But I keep getting an error message and it looks at the 2nd ,0, in the
> formula.

[kassie]

What are you trying to achieve here?
are you trying to say
=IF(ISERROR(VLOOKUP(A2,ydt,2,FALSE)),0,VLOOKUP(A2,ydt,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk1t,2,FALSE)),0,VLOOKUP(A2,wk1t,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk2t,2,FALSE)),0,VLOOKUP(A2,wk2t,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk3t,2,FALSE)),0,VLOOKUP(A2,wk3t,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk4t,2,FALSE)),0,VLOOKUP(A2,wk4t,2,FALSE))))))


"John K" wrote:

> I want to add 5 multiple vlookups together. Here's what I got:
>
> =if(iserror(VLOOKUP(A2,ydt,2,false)),0,VLOOKUP(A2,ydt,2,false)+iserror(VLOOKUP(A2,wk1t,2,false)),0,VLOOKUP(A2,wk1t,2,false)+iserror(VLOOKUP(A2,wk2t,2,false)),0,VLOOKUP(A2,wk2t,2,false)+iserror(VLOOKUP(A2,wk3t,2,false)),0,VLOOKUP(A2,wk3t,2,false)+iserror(Vlookup(a2,wk4t,2,false)),0,vlookup(a2,wk4t,2,false)
>
> But I keep getting an error message and it looks at the 2nd ,0, in the
> formula.

[Kevin Vaughn]

Oops, this looks more like it will work then what I said.
--
Kevin Vaughn


"kassie" wrote:

> What are you trying to achieve here?
> are you trying to say
> =IF(ISERROR(VLOOKUP(A2,ydt,2,FALSE)),0,VLOOKUP(A2,ydt,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk1t,2,FALSE)),0,VLOOKUP(A2,wk1t,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk2t,2,FALSE)),0,VLOOKUP(A2,wk2t,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk3t,2,FALSE)),0,VLOOKUP(A2,wk3t,2,FALSE)+IF(ISERROR(VLOOKUP(A2,wk4t,2,FALSE)),0,VLOOKUP(A2,wk4t,2,FALSE))))))
>
>
> "John K" wrote:
>
> > I want to add 5 multiple vlookups together. Here's what I got:
> >
> > =if(iserror(VLOOKUP(A2,ydt,2,false)),0,VLOOKUP(A2,ydt,2,false)+iserror(VLOOKUP(A2,wk1t,2,false)),0,VLOOKUP(A2,wk1t,2,false)+iserror(VLOOKUP(A2,wk2t,2,false)),0,VLOOKUP(A2,wk2t,2,false)+iserror(VLOOKUP(A2,wk3t,2,false)),0,VLOOKUP(A2,wk3t,2,false)+iserror(Vlookup(a2,wk4t,2,false)),0,vlookup(a2,wk4t,2,false)
> >
> > But I keep getting an error message and it looks at the 2nd ,0, in the
> > formula.