G
Guest
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.
=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.