Thread: Variables in excel

I have been asked to complete a project at work, on excel. My excel skills are averagely dull. Let me explain the problem at hand.

I work for resin manufacturer and all the different resins that we produce, have product codes. Each resin that is drummed, is called a batch. Each batch has a timeframe that it takes to make. The guys upstairs (in operations) wants the following from me...

They want excel to automatically display the batch times of each product, by simply typing in the product code. The problem I am facing is uncertainty - I don't even know where to start. My logic tells me that I will need to create a database to store the batch times as variables, after which excel will call up the batch time upon the entry of a product code...however, this is way above my knowledge of excel and I am also not too great with access, is there perhaps an easier way?

Much appreciated,
Martin

P.S: attached is a workbook with an example of the batch times and product codes.

Hi,
May be with pivot table
See attached 2 solutions as I don't know how your data table is distributed :
- 2 columns (reactor + time) = 1 product = 1 reactor
- 1 row = 1 product = 3 reactors
Note :
- in case 1 : I rearrange your data and you can see that you have a lots of duplicate data
Hope this helps

Thank you so much, I will study both examples when I get home and let you know how it goes! I appreciate your assistance!

Martin