Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding multiple vlookups
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding multiple vlookups
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,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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding multiple vlookups
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding multiple vlookups
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,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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding off of multiple sheets | Excel Discussion (Misc queries) | |||
Sum a row of multiple vlookups | Excel Worksheet Functions | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions | |||
Vlookups and multiple returns (again!) | Excel Worksheet Functions |