Thread: how do i use vlookup and add all the results in pulls?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keith Keith is offline
external usenet poster
  
Posts: 262
Default how do i use vlookup and add all the results in pulls?
I want to be able to look up all occurances in column A for 1000 and add the
corresponding results in column B. So that column E will show the results for
product "1000".

A B D E
1 1000 5 1000 = 7
2 3000 6 2000 = 0
3 1000 2 3000 = 6

Do I use VLOOKUP? How do I get it to add the results from column B?
Reply With QuoteReply With Quote