changing between sets of data

Originally Posted by crowner

I hope its ok to post requests for help like this here - I really dont know where to start. I am quite new to any kind of complicated tasks with Excel. I might not even be using the right program. I would hugely appreciate some guidance.

I have a list of component parts. Depending on the supplier the prices for the parts vary, so I have several different sets of prices.

Eg - components in a table with 3 price lists
component x || 455 || 420 || 467
component y || 233 || 240 || 213
component z || 90 || 88 || 94

Ive created quite a few tables representing the packages that these components make up. Different packages include various components in varying quantities.

If there was just one price list then I can use Excel enough to calculate the cost for the multiples of components, and so get a final cost for each given package. But what I am trying to do is be able to select which price list I want to use for the calculation. Ideally Id like to be able to add further price lists and so increase the selection of price lists available over time when Im pricing up packages. Is there someway I can set a flag on the spreadsheet to say "use price list A" etc, which will make all the package pricing calculations being carried out use that particular price list?

Thanks

see the attached file, hope this would help.

Originally Posted by crowner

Thats great! Thanks. I'll spend a bit of time working it out and trying to develop it to fit my data. If I get stuck I'll let you know.

You are welcome all the time. Thank you for the feedback.