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