View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nt nt is offline
external usenet poster
 
Posts: 10
Default vlookup addition

I am using the following to add together the two categories. How can I
change it to still give me a sum even if one of the categories is missing?
Example: The June report shows a category of Sales & Logistics but doesn't
even mention Accounting. Using this formula gives me an error although I
still need to have an amount even if the Accounting category is missing. Is
this possible? Thanks in advance!!!

=VLOOKUP("Accounting",$G$1:$H$205,2,FALSE)+VLOOKUP ("Sales",$G$1:$H$205,2,FALSE))+VLOOKUP("Logistics" ,$G$1:$H$205,2,FALSE)