Bob,

Thanks for the suggestion for the formula.

Would that work even if the two are not matched up at all? For example:

- if list 1 is 200 lines and list 2 is only about 20 lines,
- the two lists are on the same worksheet in the columns you mentioned,
but they are not lined up or matched up in any way by name or age group
- not all people and age group in list 2 have a corresponding match in
list 1

would that formula still work?

I also must admit that the data is currently all on one worksheet in
pivot table ready form, basically the second way I mentioned - a dataset
with the following headings:

name age group measurement value
Mary 8-10 money saved $75
Mary 8-10 interest rate .5
Bob 8-12 interest rate .7
Bob 8-12 money saved $50

Are there some other approaches you may suggest as to how to multiply
the data from this dataset?

Thanks again.

Marina


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!