Multiple VLookup in Excel 2000 1

[CH99]

I need a function similar to Excel's standard vlookup function where I can lookup a value in cell A1 of Sheet 1 in a range located on Sheet 2 and once it finds a match return a value located in column C on Sheet 2. However, there may be more than one exact match in the range located in Sheet 2 and I want to continue the vlookup loop, each time adding the value in column C of the new line to the first value that was found in order to subtotal all the values in C with the corresponding match value from column A. Any help is greatly appreciated.

 

[DaleWatson123321]

CH99,

Excel's database functions (=DSUM in this case) would be ideal for your situation.

Many Excel users unfortunately have not used this component of Excel, which includes the ability to selectively extract data, based on the same criteria you would use for your formulas - i.e. to isolate the "data behind the formula".

If you'd like a "jump start" with using this option, perhaps you could email me your file, or a scaled down version. If you have sensitive data, replace it with fictitious data that still reflects the type of data you're working with. I'll then modify your file and return it.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[CH99]

Great! Thanks for the tip - it works great!