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,w k2t,2,FALSE)),0,VLOOKUP(A2,wk2t,2,FALSE)+IF(ISERRO R(VLOOKUP(A2,wk3t,2,FALSE)),0,VLOOKUP(A2,wk3t,2,FA LSE)+IF(ISERROR(VLOOKUP(A2,wk4t,2,FALSE)),0,VLOOKU P(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,V LOOKUP(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)+iser ror(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.