LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return the Cell address of a value Jack_442 Excel Worksheet Functions 3 September 12th 09 03:55 AM
vlookup for an unique Text and return its address? Narnimar Excel Discussion (Misc queries) 2 July 2nd 09 04:14 AM
USING VLOOKUP TO RETURN A CELL ADDRESS psych142 Excel Worksheet Functions 5 December 8th 08 01:04 AM
Return a cell address Frank Pytel Excel Worksheet Functions 5 October 31st 08 12:19 PM
LOOKUP & RETURN CELL ADDRESS Carolan Excel Worksheet Functions 12 June 2nd 08 07:53 AM


All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"