View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Haack Steve Haack is offline
external usenet poster
 
Posts: 44
Default VLOOKUP to return Cell Address

I have a table, and I want to do a Vlookup on Column1, and when I find what I
am looking for, I want to sum column 2 from that row down to the bottom of
the table.

For example,
Item 1 2345
Item 2 3478
Item 3 1298
Item 4 123
Item 5 1233

I want to find "Item 3" and then I want to be able to return the sum of
(1298+123+1233).

How would I do this? My thoughts were that I would do a lookup to get the
row numner of "Item 3" and then do a sum() with the cell range starting from
the row where I found "Item 3" but I'm not sure how to do that.

Thanks,
Steve