Good afternoon whizzy Excel people, I wonder if anyone can help me solve a problem that I'm trying to come up with a formula for, I'm usually pretty good at this sort of thing but this one is eluding me, no doubt someone out there has a simple answer using a function I haven't come across yet, well one would hope it will be that simple.
So what I am trying to calculate is the number of units required of each of the three items in the table below to hit the total value required of a/b/c in the second table, does that make sense to anybody? The number doesn't have to be bang on exactly, just there or there abouts #HELP
<tbody>
</tbody>
This problem has had me pulling my hair out so thought I would ask the experts, all help appreciated #thanks
So what I am trying to calculate is the number of units required of each of the three items in the table below to hit the total value required of a/b/c in the second table, does that make sense to anybody? The number doesn't have to be bang on exactly, just there or there abouts #HELP
1 unit value | Total value required | |||||||
Item | a | b | c | a | b | c | ||
item 1 | 40 | 12 | 1 | ? | 55 | 29 | 12 | |
item 2 | 20 | 8 | 2 | ? | ||||
item 3 | 6 | 3 | 24 | ? |
<tbody>
</tbody>
This problem has had me pulling my hair out so thought I would ask the experts, all help appreciated #thanks