#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 127
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default 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!




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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!




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUM with nested VLOOKUPS - can i make it ignore N/As? JW73 Excel Worksheet Functions 5 July 9th 08 09:09 PM
Dependent vlookups - nested vlookups (maybe) Maniv Excel Worksheet Functions 1 April 22nd 08 07:40 PM
Nested Vlookups TarekHamouda Excel Worksheet Functions 2 April 12th 06 07:39 AM
Limit to nested Vlookups karambos Excel Discussion (Misc queries) 2 August 26th 05 01:55 PM
Nested count and vlookups Chrisnelsonusa Excel Discussion (Misc queries) 1 June 6th 05 07:58 PM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"