I am trying to develop a file for budgets/costs in a publishing environment.
The main variables a title (any one of 7), print run (a range from 3,000
to 20,000) and pagination (ranges from 24 + cover to 120 + cover).

Currently the summary worksheet allows the user to select €˜title, €˜print
run and €˜pagination data from 3 drop-down lists.

I need to now use the data selected from the lists to extract various costs
from ranges on other worksheets and put the figures into the appropriate
budget item cells.

For example, the €˜Printing & Binding cost item for a specific title would
be stored in a range as the relevant print price for a combination of print
run and page count, eg, printrun = 6000; page = 68; cost = $12,000. The
€˜cost figure is what the user needs to see on the summary sheet.

Im assuming each title would have its own Lookup range on a separate
worksheet.

Would I be best using a conditional Lookup for this kind of thing? And if
so, how would I create the formula? Or is there a smarter way to do it €“ Ive
only ever used Excel for relatively simple things before this.