LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 683
Default Lookup with multiple results

On Tab 1 of my spreadsheet, I have the following data

A-Bank Name B-Fund Type C-Amount
D-Maturity Date
1 ABC Bank MMF $1,000
03/05/09
2 BCD Bank MMF $500
03/05/09
3 ABC Bank Comm Paper $2,000
03/10/09
4 ABC Bank Treasury Fund $600
03/05/09

On Tab 2, I'd like to have a formula that will provide me the Fund Type and
Sum of the amounts held by bank based on their maturity date...
For example...on Tab 2....I'd like to have:
ABC Bank 03/05/09 (maturity date) MMF &
Treasury Fund $1,600

I'd like to fill in the bank name and Maturity date fields...but would like
a formula that will list the fund descriptions together "MMF & Treasury
Fund"....as well as add the amounts together.

I can't seem to get an Index or Match function to work...and don't want to
use the Filter function since they are on seperate tabs. Any help would be
appreciated!
 
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
Lookup with Multiple results Quovardis via OfficeKB.com Excel Worksheet Functions 7 October 12th 07 06:28 AM
single lookup value with multiple results aramancam Excel Worksheet Functions 1 April 6th 07 09:46 PM
Lookup multiple results with gaps Fin Fang Foom Excel Worksheet Functions 8 November 14th 06 12:53 AM
Lookup with multiple results, without duplicates Rothman Excel Worksheet Functions 3 March 10th 06 09:24 PM
How can I do a lookup and get multiple row results? Rashmi Excel Worksheet Functions 10 August 19th 05 02:04 AM


All times are GMT +1. The time now is 02:42 PM.

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"