Thread: nested vlookups
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_3_] Gaurav[_3_] is offline
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!