Returning the correct value from a pricing grid
 

Hi Group,

I am not sure if I am doing this right - would appreciate
some expert help as I completely stuck.
A solver routine returns no of units to produce. (Col B)
I have a pricing grid that must be applied to calculate
total costs of units produced. (Col D)
How do I 'pick up the costs' from my pricing grid to
produce Total costs (and influence Solver when it is run
again).
For example, 275 units are required to be built for Part1,
which equals £495. (275 x £1.80)

Here is a sample of the tables that I am using (starting
point appears in top left corner)

A1 Units Price Cost
Part1 275 ? ?
Part2 450 ? ?
Part3 202 ? ?
Part4 260 ? ?


A20 <100 <200 <300 <400 <500
Part1 £1.10 £1.70 £1.80 £1.90 £2.00
Part2 £1.90 £2.00 £2.10 £2.20 £2.30
Part3 £1.50 £1.60 £1.70 £1.80 £1.90
Part4 £1.80 £1.90 £2.00 £2.10 £2.20

Appreciate any help

Chris