Matrix Table to autopopulate

Hi guys.

This seems quite difficult so any advise would be extremely appreciated, if its even possible to do.

Essentially I have a matrix currently, that has data points going across the top, then additional data points going down a column also. Then I when I receive 2 seperate figures, I have to match them up to data points on my matrix and find the applicable number and multiply it by one of the data points.

I'm looking to see if there is a way I can automate it, so If I put data into a table / chart, it automates itself and provides a figure.

Again, any help would be great.

Hi Avk,

Thank you for responding. Apologies for not making myself clear enough.

Find attached in which I've explained a litte more indepth as to what I'm trying to get across.

Many thanks,
Dom

Are the headers the actual values (more specifically, are they always multiples of 10)?

From what you've provided, you aren't multiplying DATA B by anything. You're multiplying DATA B rounded up to the next 10 by the intersection. The results are different.

Please Login or Register  to view this content.

The first result is 162.9 (the result you got).
The second result (what you SAID you wanted) is 152.04.

These formulas are based on the assumption that both DATA A and DATA B headers are always multiples of 10.