View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jhillman jhillman is offline
external usenet poster
 
Posts: 1
Default Totaling VLookup

I am trying to get a total of items in a list by category using vlookup.
I have a list of 20 different transactions, there might be 8 of them that
are one specific category and I want those to total. My current Vlookup
formula is this: =(VLOOKUP($I3,$C$3:$E$15,2,FALSE)) and this gives me the
first amount in my array, but I want it to give me a total of all amounts in
my array with the specific category.