|
nested vlookups
I have a vlookup formula
=IF(ISERROR(VLOOKUP(O2,data,10,FALSE))=TRUE,0,VLOO KUP(O2,data,10,FALSE)) which works fine, now I need to add another vlookup to this formula so that the results sum both lookups. I've tried many ways, no luck yet, any ideas, please send exact formula Louie appreciates your help! |
nested vlookups
Please give exact details of the exact formula you want.
"Louie" wrote in message ... I have a vlookup formula =IF(ISERROR(VLOOKUP(O2,data,10,FALSE))=TRUE,0,VLOO KUP(O2,data,10,FALSE)) which works fine, now I need to add another vlookup to this formula so that the results sum both lookups. I've tried many ways, no luck yet, any ideas, please send exact formula Louie appreciates your help! |
nested vlookups
Gaurav - somethiung like
=IF(ISERROR(VLOOKUP(917045,data,10,FALSE))=TRUE,0, VLOOKUP(917045,data,10,FALSE)) + vlookup(918045,data,10,false)=true,0,(vlookup(9180 45,data,10,false)) I need to sum the vlookup for 917045 plus 918045 in one formula -- Louie appreciates your help! "Gaurav" wrote: Please give exact details of the exact formula you want. "Louie" wrote in message ... I have a vlookup formula =IF(ISERROR(VLOOKUP(O2,data,10,FALSE))=TRUE,0,VLOO KUP(O2,data,10,FALSE)) which works fine, now I need to add another vlookup to this formula so that the results sum both lookups. I've tried many ways, no luck yet, any ideas, please send exact formula Louie appreciates your help! |
nested vlookups
=IF(COUNTIF(data,917045),VLOOKUP(917045,data,10,), 0)+IF(COUNTIF(data,918045),VLOOKUP(918045,data,10, ),0)
"Louie" wrote: Gaurav - somethiung like =IF(ISERROR(VLOOKUP(917045,data,10,FALSE))=TRUE,0, VLOOKUP(917045,data,10,FALSE)) + vlookup(918045,data,10,false)=true,0,(vlookup(9180 45,data,10,false)) I need to sum the vlookup for 917045 plus 918045 in one formula -- Louie appreciates your help! "Gaurav" wrote: Please give exact details of the exact formula you want. "Louie" wrote in message ... I have a vlookup formula =IF(ISERROR(VLOOKUP(O2,data,10,FALSE))=TRUE,0,VLOO KUP(O2,data,10,FALSE)) which works fine, now I need to add another vlookup to this formula so that the results sum both lookups. I've tried many ways, no luck yet, any ideas, please send exact formula Louie appreciates your help! |
nested vlookups
Thanks T Mama, however this formula returns an error when I use non-numeric
characters. I have the same problem when I lookup many accounts this way, the formula is too long. I've busted up the lookups into two formulas & then add the two cells together for the total. Thanks for your help. -- Louie appreciates your help! "Teethless mama" wrote: =IF(COUNTIF(data,917045),VLOOKUP(917045,data,10,), 0)+IF(COUNTIF(data,918045),VLOOKUP(918045,data,10, ),0) "Louie" wrote: Gaurav - somethiung like =IF(ISERROR(VLOOKUP(917045,data,10,FALSE))=TRUE,0, VLOOKUP(917045,data,10,FALSE)) + vlookup(918045,data,10,false)=true,0,(vlookup(9180 45,data,10,false)) I need to sum the vlookup for 917045 plus 918045 in one formula -- Louie appreciates your help! "Gaurav" wrote: Please give exact details of the exact formula you want. "Louie" wrote in message ... I have a vlookup formula =IF(ISERROR(VLOOKUP(O2,data,10,FALSE))=TRUE,0,VLOO KUP(O2,data,10,FALSE)) which works fine, now I need to add another vlookup to this formula so that the results sum both lookups. I've tried many ways, no luck yet, any ideas, please send exact formula Louie appreciates your help! |
| All times are GMT +1. The time now is 05:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com