nested vlookups

  • Thread starter Thread starter Louie
  • Start date Start date
L

Louie

I have a vlookup formula
=IF(ISERROR(VLOOKUP(O2,data,10,FALSE))=TRUE,0,VLOOKUP(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!
 
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(918045,data,10,false))

I need to sum the vlookup for 917045 plus 918045 in one formula
 
=IF(COUNTIF(data,917045),VLOOKUP(917045,data,10,),0)+IF(COUNTIF(data,918045),VLOOKUP(918045,data,10,),0)
 
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.
 
Back
Top